logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Move selected data (only values)...

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

Range  ›  16. Move selected data (only values)...

This utility moves the content of your selected range to another location.

It is a bit similar to "cut" and "paste" but instead of the built in Excel method, it will only paste the values.
Moreover it will not update any cell references. If you move your data Excel automatically adjusts the formula references to point to the new location. This utility prevents that. For example if you have a formula with a reference to range A1:B10 and you use this utility to move the contents of cell A1:B10 to another location, the formula will still use to A1:B10.
If you your range contains cells with formulas then these will be replaced with their calculated value.

Starting this tool

Copy formulas without changing their cell references...

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