Excel Shortcut Paste Values

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.

You can download this Shortcuts to Paste Values Excel Template here – Shortcuts to Paste Values Excel Template
  • Look at the below data first.
Excel Shortcut Paste Values - Example 1
  • Now we will copy this table and past it in E1 cell.
Shortcut Paste Values - Example 1-1

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.
Shortcut Paste Values - Example 1-2
  • 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.
Shortcut Paste Values - Example 1-3
  • Now, look at the result of the table.
Shortcut Paste Values - Example 1-4

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 keys 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.

  1. First, copy the range of cells.

    Shortcut Paste Values - Example 1-5

  2. Now select the cell or range of cells where we need to paste the copied data.

    Shortcut Paste Values - Example 2-1

  3. 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.

    Shortcut Paste Values - Example 2-2

  4. 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.

    Shortcut Paste Values - Example 2-3

  5. After selecting the “Values” option, click on the “Ok” button to get only values.

    Shortcut Paste Values - Example 2-4

#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.

Shortcut Paste Values - Example 3
Press shortcut key

Note: You need to hold Ctrl + ALT key together and then press “V” to open paste special dialogue box.

Shortcut Paste Values - Example 3-1

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.

Example 4

After copying the cell, click on the drop-down list to see a variety of paste special options.

Example 4-1

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.

Example 5

Drag the table to the right side by using the right click of the mouse; it will open up the below options.

Example 5-1

Choose the “Copy Here as Values Only” option to paste as value.

Example 5-2

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 –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>