Keyboard Shortcuts to Paste Values in Excel
Copy & Paste are all the common tasks that are performed every day at workplaces. One of the advantages in excel is we can choose a wide variety of pasting options; pasting only values allows us to eliminate any sort of formatting and formula from the copied cell to the pasting cell. Pasting values is the often used method among many paste special options. To perform this operation quickly and efficiently, a shortcut is the way. So in this article, we will show ways of pasting values using shortcut keys in excel.
Examples to Paste Values in Excel
Let us understand the excel shortcut paste values concept first.
- Look at the below data first.
- Now we will copy this table and past it in E1 cell.
As you can see, it has exactly looked like the left table, but using paste special, we can get only values nothing else.
- First, copy the table and select the cell E1.
- Now, right-click to see a variety of options; paste special is also the options in this. So choose the “Values” option to paste as values.
- Now, look at the result of the table.
Now the pasted table has no formatting from the copied; rather, it has only the existing format of the pasted range of cells.
How to Paste Values Using Excel Shortcut Key?
Below are the examples of paste values using excel shortcut key:
#1 – Paste Values Using Shortcut Key “ALT + E + S + V”
Once the data range of cells is copied, if we don’t want the formatting or any formula from the copied cell or range of cells, then we can use the “Paste as Values” option from “Paste Special” options.
The shortcut key to paste as values is “ALT + E + S + V.”
Not only this is the shortcut, but there are other alternative excel shortcut keysExcel Shortcut KeysAn Excel shortcut is a technique of performing a manual task in a quicker way. are also available; we will see those in a while now; first, let’s see this shortcut.
Follow the steps to paste values in excel using shortcut key.
- First, copy the range of cells.
- Now select the cell or range of cells where we need to paste the copied data.
- Now press the shortcut key “ALT + E + S” (all keys one by one, do not hold any key), it will open up a wide variety of paste special options.
- From this list, we need the option of “Values” so to select this option in this window, we can press the shortcut alphabet “V,” and it will choose the “Values” options in this “Paste Special” window.
- After selecting the “Values” option, click on the “Ok” button to get only values.
#2 – Paste Values Using Shortcut Key “Ctrl + ALT + V”
The second shortcut key is to open paste special dialogue box is “Ctrl + ALT + V” this will open up the paste special dialogue box, and from there on, press “V” to select the “Values” option.
Copy the range of cells to be pasted, then select the targeted cell where we need to paste as values. Now hold “Ctrl + ALT” and press “V” to open the “Paste Special’ dialogue box.
Note: You need to hold Ctrl + ALT key together and then press “V” to open paste special dialogue box.
Once the above dialogue box comes up, press “V” to choose the “Values” option and hit enter key to paste as values.
So, second shortcut key “Ctrl + ALT + V + V”.
#3 – Paste Values Using Shortcut Key “ALT + H + V + V”
Not many of us aware us that we have paste special option in the Home tab as well.
After copying the cell, click on the drop-down list to see a variety of paste special options.
Choose the “Values” option to paste as values; it will paste as values.
The shortcut key for this is “ALT + H + V + V”.
Like this, using multiple shortcut keys, we can paste as values.
#4 – Unknown Method to Paste Values
This is a hidden method that not many people know about it. Select the range of cells to be paste.
Drag the table to the right side by using the right click of the mouse; it will open up the below options.
Choose the “Copy Here as Values Only” option to paste as value.
Things to Remember
- ALT + E + S + V is the common shortcut key to paste as values.
- ALT + H + V + V is the another unknown shortcut key.
- Paste Values will paste only values, not any formatting or formulas.
This has been a guide to Excel Shortcut Paste Values. Here we discuss the 4 different shortcut keys to paste values in excel along with practical examples and a downloadable excel template. You may learn more about excel from the following articles –