Introduction to Excel Shortcut Paste Values
The most common task that I ever perform in Excel is Copy and Paste. I am sure you all will be agree with the statement. Since it is one of the most performed activities within the tool, it has a variety of shortcuts to get work done as well as to save time. I don’t think we would have anyone in the crowd that doesn’t know Ctrl + C and Ctrl + V shortcut in Excel which allows us to copy and paste the values in different cells, different sheets, etc. Since it is a day-to-day task, we have a lot of other options available under pasting content in Excel from one cell/sheet to another; and for that sake, we have different shortcuts associated with all these options. In this article, we are going to have an introduction to all these shortcuts and will try to explain those with a handful of examples.
What is Shortcut Paste Values?
What you do when you need content from one cell/sheet to be copied the same as it is into another cell/sheet?
You copy it and tries to paste the same into another cell/sheet, right?
If you go by normal methods, you need to go to the Home tab > select Copy option under Clipboard section > Navigate towards the area where you need to paste the values and then select Paste option under the same Clipboard section under Home tab. See the screenshot below:
To make this process faster, we have a keyboard shortcut in Excel for the same. You can copy the cell values by hitting Ctrl + C and paste it by hitting Ctrl + V.
This is how a shortcut for Paste value works. It saves you a lot of time plus efforts and makes the task look easier. In this article, we are going to see different shortcuts associated with pasting the values.
Example #1 – Excel Paste as Value
Sometimes, you don’t need the format of the copy source to the destination where you want to paste the values. In Excel, this is called Excel Paste Special option.
Suppose we have data as shown in the screenshot below:
All we need to do is copy this data and paste it under column E onwards on the same sheet. We can use Ctrl + V keystrokes from the keyboard to achieve this result. See the screenshot below:
However, this is not we actually wanted. We need the data towards right without the source formatting (there should be no color values or other formatting from source data). Let’s see how to achieve that.
Step 1: Copy the values across A1:C13 by selecting the cells and hitting Ctrl + C.
Step 2: Move towards column E and navigate to cell E1.
Step 3: Now, instead of using traditional Ctrl + V to paste values under column E onwards, right-click on the cell E1 and select Paste as Values option out of all possible list of Paste Options: See the screenshot below:
Once you click on that option, you can see that the values are pasted across column E onwards. However, this time, there is no formatting involved in the resulted data. It would be simple values pasted without formatting. See the screenshot below:
16 Online Courses | 23 Hands-on Projects| 140+ Hours| Verifiable Certificate of Completion
4.8
View Course
However, there is a keyboard shortcut that can save you a lot of time for pasting data as values only (without source formatting). You can hit Alt + E + S + V as a combination of keystrokes which allows you to paste copied data as values and without any source formatting (no font colors, cell colors, borders, nothing).
Step 1: Copy the entire data from A1:C13 using Ctrl + C.
Step2: Now, Navigate towards column E. Click select the Cell E1 and press keyboard shortcut Alt + E + S. This will open up the Paste Special window with multiple options.
Step 3: Now, after you used Alt + E + S, use V from your keyboard and you will see that the Values radio button will be active in the Paste option under Paste Special Window. Hit OK after this and you are through.
The cells copied will be pasted as values from cell E1 onwards as shown below:
Paste Special Shortcut No. 2
There are other shortcuts as well for paste special. We will move towards the next one in line which is Ctrl + Alt + V + V.
Step1: Copy the data first as we did in the previous example and move towards the destination where you wanted to paste the data. Click select cell E1 from the destination column.
Step 2: Now, hold Ctrl + Alt keys from your keyboard and hit V to open up Paste Special window that allows us to paste values as special.
Step 3: Now, hit V one more time to automatically select the paste type as Values under Paste section. And hit OK button to see the output.
Ctrl + Alt + V + V also allows you to paste cells as special values in Excel. Nevertheless, you can choose other options as well (everyone has a unique keyboard key assigned with it to get executed).
Paste Special Shortcut No. 3
Third and last shortcut which we can use to paste special values is Alt + H + V + V.
Step 1: Copy the source data using Ctrl + C. Move to column E and click select cell E1. This is where we will paste the data.
Step 2: Now, hit Alt + H + V keystroke from your keyboard in the sequence and you will see all the paste options under the Home tab are active as shown in the image below:
Step 3: Hit V keystroke one more time which is associated with Paste as Values. This will allow the system to paste the data copied as value (without source formatting) under column E onwards.
This how we can paste values using excel shortcuts. Let us discuss some points to be remembered before closing this out.
Points to Remember
- Alt + E + S + V is the most frequently used shortcut key combination for pasting data as values.
- Paste as Values option allows us to paste the values and source formatting does not get applied in the values pasted under destination.
- There are other options for pasting values as well which we can use under Paste Special window and have different dedicated shortcuts to those operations. You can explore the ones
- We can also Use Ctrl + Alt + V + V or Alt + H + V + V as shortcut to paste cells as values only.
Let’s stop here and we will come up with new exciting article next time for you. Until then, stay safe! 😊
Recommended Articles
This is a guide to Excel Shortcut Paste Values. Here we discuss the Introduction, What is Shortcut Paste Values? and examples. You may also have a look at the following articles to learn more –
