Copy the cells with Ctrl + C, select the destination, then press Alt, H, V, V one key after another. Excel pastes only the values: formulas become their results and the source formatting is left behind.
The Paste Special route does the same: press Ctrl + Alt + V, then V for Values, then Enter. To keep number formats such as dates, currency and percentages, press Alt, H, V, A (Values & Number Formatting) instead, or U in the Paste Special dialog.
Recent Microsoft 365 builds for Windows add Ctrl + Shift + V to paste values in one step. Older versions don’t have it, so test it in your build before you rely on it.
To turn formulas into fixed values in place, select the range, press Ctrl + C, then press Alt, H, V, V without moving the selection.
If you cut with Ctrl + X, Paste Values and Paste Special aren’t available, so copy instead. And plain Values drops number formats, so a date can land as a serial number such as 45658 in a General-formatted cell; use Values & Number Formatting to keep it readable.
Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)
In Excel, copying and pasting is a very common task that everyone performs. Whenever a user copies data and pastes it, Excel not only pastes the values but also the formatting and formula.
However, Excel also has the option to paste the data as values only, which means that with that option, only the value would be pasted, and formatting and formulas would be eliminated.
There are multiple shortcuts and key combinations to paste the data as a value only in Excel, but in this tutorial, we have explained the quickest and easiest shortcuts.
Keyboard Shortcuts to Paste Values in the Excel
In Excel, the quickest and easiest shortcuts for paste values are mentioned below:
Alt → H → V → V
Steps to Paste Values Using Keyboard Shortcut
- First, copy the data you want to paste somewhere else in Excel.
- After that, go to the cell where you want to paste the data.
- Now, press Alt → H → V → V in sequence, and you will get your data pasted as values only.
- Or press and press and hold the “Ctrl + Alt +V” keys, and you will get the “Paste Special” dialog box opened.
- Now, release the keys and press “V” to move the radio button to “Values” and press enter.
