logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Range » 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 utility

In the Excel menu choose: ASAP Utilities » Range » Move selected data (only values)...

« Return to the list of “Range” tools.
«
Copy formulas without changing their cell references...
 
  »
Copy multiple selected ranges...
Excel 2010 with ASAP Utilities in the menu
Download ASAP Utilities

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook