Paste Values | Keyboard Shortcut | Microsoft Excel

HomeExcel Keyboard ShortcutsPaste Values | Keyboard Shortcut | Microsoft Excel

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:

paste-values-shortcut-keys

Alt → H → V → V           

paste-value-shortcut

Ctrl + Alt + V → V

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.
paste-special-dialog-box

➜ Excel Shortcuts Cheat Sheet (PDF)