The first method is to paste special contents in your table.
#EXCEL SHORTCUT KEYS PASTE SPECIAL VALUES HOW TO#
Today we will learn how to utilize Paste Special in excel. However, few people are aware of its true power. Here we discuss the 4 different shortcut keys to paste values in excel along with practical examples and a downloadable excel template.Copy-paste has always been one of the most frequently-used functions in excel. This has been a guide to Excel Shortcut Paste Values. Paste Values will paste only values, not any formatting or formulas.ALT + H + V + Vis the another unknown shortcut key.ALT + E + S + Vis the common shortcut key to paste as values.Select the range of cells to be paste.ĭrag the table to the right side by using the right click of the mouse it will open up the below options.Ĭhoose the “Copy Here as Values Only” option to paste as value. This is a hidden method that not many people know about it. Like this, using multiple shortcut keys, we can paste as values. The shortcut key for this is “ALT + H + V + V”. Not many of us aware us that we have paste special option in the Home tab as well.Īfter copying the cell, click on the drop-down list to see a variety of paste special options.Ĭhoose the “Values” option to paste as values it will paste as values. #3 – Paste Values Using Shortcut Key “ALT + H + V + V” So, second shortcut key “Ctrl + ALT + V + V”. Once the above dialogue box comes up, press “V” to choose the “Values” option and hit enter key to paste as values. Note: You need to hold Ctrl + ALT key together and then press “V” to open paste special dialogue box. Now hold “Ctrl + ALT” and press “V” to open the “Paste Special’ dialogue box. “Ctrl + ALT + V”Ĭopy the range of cells to be pasted, then select the targeted cell where we need to paste as values. The second shortcut key is to open paste special dialogue box is this will open up the paste special dialogue box, and from there on, press “V” to select the “Values” option. #2 – Paste Values Using Shortcut Key “Ctrl + ALT + V” After selecting the “Values” option, click on the “Ok” button to get only values.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.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.Now select the cell or range of cells where we need to paste the copied data.
#EXCEL SHORTCUT KEYS PASTE SPECIAL VALUES MANUAL#
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.read more are also available we will see those in a while now first, let’s see this shortcut.įollow the steps to paste values in excel using shortcut key. The shortcut key to paste as values is “ALT + E + S + V.”
![excel shortcut keys paste special values excel shortcut keys paste special values](https://i.ytimg.com/vi/jd9PZd7Itzs/maxresdefault.jpg)
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. How to Paste Values Using Excel Shortcut Key?īelow are the examples of paste values using excel shortcut key: #1 – Paste Values Using Shortcut Key “ ALT + E + S + V” Now the pasted table has no formatting from the copied rather, it has only the existing format of the pasted range of cells. So choose the “Values” option to paste as values. Now, right-click to see a variety of options paste special is also the options in this.
![excel shortcut keys paste special values excel shortcut keys paste special values](https://i.ytimg.com/vi/6bLcvRb70_Y/maxresdefault.jpg)
![excel shortcut keys paste special values excel shortcut keys paste special values](https://cdn.wallstreetmojo.com/wp-content/uploads/2018/10/Paste-Special-Example-4-2-768x402.jpg)