The ASAP Utilities menu in Excel (English)
Cut and Paste as Values (Keeping Dependents Unchanged)...
ASAP Utilities › Range › 16. Cut and Paste as Values (Keeping Dependents Unchanged)...This tool lets you move a selected range to a new location while converting any formulas within that range into their calculated values, just like using Paste Special > Values. Unlike Excel's standard Cut and Paste, which automatically updates any dependent formulas (formulas referencing the moved cells), this tool leaves those references unchanged. This makes it easy to relocate data without having to worry about unexpected formula adjustments elsewhere in your workbook.
Starting this tool
- Click ASAP Utilities › Range › 16. Cut and Paste as Values (Keeping Dependents Unchanged)...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords for this tool:
Move data without updating formulas, Excel cut and paste alternative, Keep dependent formulas unchanged, Data relocation tool, Maintain dependent formula references in Excel, Paste values without reference updates
Move data without updating formulas, Excel cut and paste alternative, Keep dependent formulas unchanged, Data relocation tool, Maintain dependent formula references in Excel, Paste values without reference updates
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Copy Formulas Without Changing Their Cell References... |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.