In Excel, copy and paste is a very common task that everyone performs, and whenever a user copies the data and pastes the same, Excel not only pastes the values but formatting and formula as well.
But Excel also has the option to paste the data as values only, which means with that option, only the value would be pasted and formatting and formula will get eliminated.
There are multiple shortcuts and key combinations to paste the data as value only in Excel, but in this tutorial, we have explained the quickest and easy shortcuts for you.
Keyboard Shortcut to Paste Values in the Excel
In Excel, the quickest and easy shortcuts for paste values are mentioned below:
Alt → H → V → V
Ctrl + Alt + V and then V → Enter
Steps to Paste Values Using Keyboard Shortcut
- First, copy the data which you want to paste somewhere else in Excel.
- After that, go to the cell where you want to paste the data.
- Now, just 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 just press “V” to move the radio button to “Values” and press enter.
More Shortcuts
- Absolute Reference (Excel Shortcut)
- Add Column (Excel Shortcut)
- Copy and Paste (Excel Shortcut)
- Cut and Paste (Excel Shortcut)
- Delete Cell (Excel Shortcut)
- Delete Row(s) (Excel Shortcut)
- Edit Cell (Excel Shortcut)
- Insert Cell (Excel Shortcut)
- Insert – Add Row(s) (Excel Shortcut)
- Lock Cells (Excel Shortcut)
- Merge-Unmerge Cells (Excel Shortcut)
- Select Row (Excel Shortcut)
- Transpose (Excel Shortcut)
- Unhide Columns (Excel Shortcut)
- Open Go To Option (Excel Shortcut)
⇠ Back to Excel Shortcut Keys (Cheat Sheet PDF)