FLASH SALE! - "CHATGPT AND ARTIFICIAL INTELLIGENCE FOR MICROSOFT EXCEL AT 60% OFF" Enroll Now

Excel Shortcut Paste Values

Updated on December 27, 2023
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Keyboard Shortcuts to Paste Values in Excel

The “Copy” and “Paste” are the common tasks performed every day at workplaces. One of the advantages of Excel is we can choose a wide variety of pasting options. The pasting only values allow us to eliminate any formatting and formula from the copied cell to the pasting cell. The pasting values are often used among many “Paste Special” options. A shortcut is a way to perform this operation quickly and efficiently. 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
  • Let us look at the below data first.
Excel Shortcut Paste Values - Example 1
  • We will copy this table and paste it into the E1 cell.
Shortcut Paste Values - Example 1-1

We can see that it looks exactly like the left table. But using the “Paste Special” method, we can get only values and nothing else.

  • First, we must copy the table and select cell E1.
Shortcut Paste Values - Example 1-2
  • Now, right-click to see various options. In this, the “Paste Special” option is also available. So, now, we must choose the “Paste as Values” option to paste the values.
Shortcut Paste Values - Example 1-3
  • Now, let us look at the result of the table.
Shortcut Paste Values - Example 1-4

The pasted table has no formatting from the copied range of cells. Rather, it has only the existing format of the pasted range of cells.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

How to Paste Values Using Excel Shortcut Key?

Below are examples of paste values using the Excel shortcut key.

#1 – Paste Values Using Shortcut Key “ALT + E + S + V”

After the data range of cells is copied, if we do not want the formatting or formula from the copied cell or range of cells, we can use the “Paste as Values” option from the “Paste Special” options.

The shortcut key to paste as values is “ALT + E + S + V.”

It is a shortcut, but other alternatives 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. But, first, let us know this shortcut.

Follow the below steps to paste values in Excel using the shortcut key.

  1. First, we must copy the range of cells.

    Shortcut Paste Values - Example 1-5

  2. Now, we must 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. As a result, 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 to open the “Paste Special” dialog box is “Ctrl + ALT + V.” This will open up the “Paste Special” dialog box. From there on, press “V” to select the “Values” option.

Then, we must copy the range of cells to be pasted and select the targeted cell where we need to paste as values. Now, we need to hold “Ctrl + ALT” and press “V” to open the “Paste Special’ dialog box.

Shortcut Paste Values - Example 3
Press shortcut key

Note: We must hold the “Ctrl + ALT” key together and press the key “V” to open the special dialog box.

Shortcut Paste Values - Example 3-1

Once the above dialog box appears, we must press the key “V” to choose the “Values” option and then press the “Enter” key to paste as values.

So, the second shortcut key is “Ctrl + ALT + V + V.

#3 – Paste Values Using Shortcut Key “ALT + H + V + V”

Not many of us know that we have a “Paste Special” option in the “Home” tab.

Example 4

After copying the cell, we must click on the drop-down list to see various “Paste Special” options.

Example 4-1

Then, we must choose the “Values” option to paste as values. Consequently, it will paste as values.

The shortcut key for this is “ALT + H + V + V”.

Like this, using multiple shortcut keys, we can paste them as values.

#4 – Unknown Method to Paste Values

It is a hidden method that not many people know about. So, first, we must select the range of cells to be pasted.

Example 5

After that, 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

Now, choose the “Copy Here as Values Only” option to paste as a value.

Example 5-2

Things to Remember

  • The “ALT + E + S + V” key is the common shortcut key to paste as values.
  • The “ALT + H + V + V” key is another unknown shortcut.
  • The “Paste Values” option may paste only values, not formatting or formulas.

This article has been a guide to Excel Shortcut Paste Values. Here, we discuss the four shortcut keys to paste values in Excel, practical examples, and a downloadable Excel template. You may learn more about Excel from the following articles: –