logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

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


Range  ›  16 Cut and Paste as Values (Keeping Dependents Unchanged)...
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

Choose your language preference below

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Download
Copy Formulas Without Changing Their Cell References...




Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


🏆 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.