The Paste Special: Values Function

 If you use Excel to create formulas, you will inevitably need to move the data result of those formulas somewhere else. We spoke a little about this in the “Holding Down the Fort – Anchors” post, but in that post what we actually did was move the formula (when we move a formula, as long as its anchored, we move the result also).

But what if you want to move ONLY the data, WITHOUT    the formula? This is where the “Copy & Paste Special - VALUES” comes in to play. By copying the formulas, then selecting the Paste Special option, you can select Values from the dialog box and paste only the result.

Throughout the years and the different versions of Excel, there have been different methods of accessing the Paste Special dialog box. Some have a button the tool bar, while others don’t. Since I don’t know which version you have, there is one method to access the Paste Special dialog box that works with all versions: Alt+E+S. (I find it quicker this way anyway!)

To use this shortcut and go directly to the Past Values function, just add a V to that shortcut: Alt+E+S+V. Striking the Enter Key (or clicking the OK button) will apply your selection (Values) and you will then have removed all the formulas while keeping the values.


Keep Excelling!

Do you like this post? Comment below and / or share on Facebook or Twitter!