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.
