Paste Special in Excel (With Top 10 Shortcuts)

Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Paste Special in Excel

Paste Special in Excel means we use this option when we want to paste only some aspects of the data rather than the original data. There are various methods to Paste Special in Excel. They are available by right-clicking on the target cell and selecting “Paste Special” or by keyboard shortcut as “CTRL + ALT + V.” Else, we can press the “ALT + E + S” shortcut keys. Furthermore, we can use the Excel shorcut of paste valuesUse The Excel Shorcut Of Paste ValuesPasting values is a common procedure that allows us to eliminate any formatting and formulas from the copied cell and paste them into the pasted cell. "Alt + E + S + V" is the shortcut key for pasting values.read more to use the aspects. Lastly, we can use the “ALT + E + S + V” shortcut keys for values only.

Sometimes in Excel, we need to perform some very real, quick things. For example, sometimes we need to copy a cell or range of cells to some other cells or range of cells along with formatting, formulas, etc. Also, we need to copy and paste only values without bringing anything else. For example, take a look at the below image.

Paste Special
Paste Special shortcut

In general, what happens if you copy a cell and paste it? First, look at the below image.

Paste Special 1

When you copy the above image value and paste it into another cell, it copies the entire thing associated with that cell. That means character size, the boldness of the font, font name, font color, font size, the border of the cell, etc.

Paste Special 2

Top 10 Paste Special Shortcuts

Below are some shortcuts that will save you a lot of time.

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

You can download this Paste Special in Excel Template here – Paste Special in Excel Template

Shortcut #1 – Paste as Values (ALT + E + S + V)

In the previous example, we know that copying the cell copies everything associated with it. Now, let us look into the Paste as Values example.

Look into the below image in cells A2 to A4. We have number 15 in cell A5. We applied the SUM formula. Suppose we copy cell A5 and paste it into C5. What happens? In a general scenario, we should get a value of 15. But, we may get the value of 30. One notable thing is it changes the color of the cell too.

Paste Special Example 1

Remember, since the formula is applied on cell A5 (range taken is A2:A4), we copied the cell and moved two cells to the right, column C. So, now it will take the reference as C2:C4 and summate 10+10+10 = 30.

Paste Special Example 1-1

Now, the requirement is to copy cell A5 and paste it into cell B8 without altering the cell of B8. So, we should get the value of 45, and the cell color should be blue only.

Steps to copy and paste only values.

  1. First, copy cell A5.


    Paste Special Example 1-2

  2. Go to B8.


    Paste Special Example 1-3

  3. Press the shortcut keys “ALT + E + S.” It will open the below dialog box.


    Paste Special Example 1-4

  4. To select the values, press V.

  5. Now, we get the value of 45 in cell 45 without changing cell B8.


    Paste Special Example 1-5

Shortcut #2 – Paste as Formulas (ALT + E + S + F)

Look into the below image. In cell A5, the SUM formula is applied. We want to copy the formula from that cell and paste it into cell C5 without changing the color of the cell. Even if we copy and paste, we may get the result. But, it will change the color of cell C5. To avoid that, we must use Paste as Formulas.

Paste Special Example 2

Now, copy cell A5, select C5, and press ALT + E + S + F. It will apply the only formula to the selected cell. It will paste only the formula. Even the boldness of the character will not be pasted.

Paste Special Example 2-1

Shortcut #3 – Paste as Format (ALT + E + S + T)

In the below image, we need to copy cell A5, which contains the formula. But, we need to paste only the cell format, neither the formula nor the value.

Paste Special Example 3
  • Copy the cell A5.
Paste Special Example 3-1
  • Go to cell C5
Paste Special Example 3-2
  • Press “ALT + E + S +T.”
Paste Special Example 3-3

Now, the result will be like the one below.

Paste Special Example 3-4

Shortcut #4 – Paste as Comment (ALT + E + S + C)

Like how we did in the previous example, we can copy and paste only the comments too. For example, look at the below image where we have a comment, “Sum Formula is Applied.Now, we need to insert the same commentInsert The Same CommentIn Excel, Insert Comment is a feature used to share tips or details with different users working within the same spreadsheet. You can either right-click on the required cell, click on “Insert Comment” & type the comment, use the shortcut key, i.e., Shift+F2, or click on the Review Tab & select “New Comment”. read more in cell C5.

  • Copy the cell A5.
Paste Special Example 4
  • Select cell C5
Paste Special Example 4-1
  • Press“ALT + E + S +C.”
Paste Special Example 4-2

Now, the result will be like the one below.

Paste Special Example 4-3

Shortcut #5 – Paste as Validation (ALT + E + S + N)

We can paste the values, formulas, and format. Similarly, we can paste the validation too.

Look into the below image where we have validation of YES and NO.

Paste Special Example 4-4

If we need to paste the same validation from cell A1 to C1,

  • Copy the cell A1
Paste Special Example 5
  • Select cell C1
Paste Special Example 5-1

Press “ALT + E + S + N.”

Paste Special Example 5-2

Now, the result will be like the one below.

Paste Special Example 5-3

Shortcut #6 – Second Part of the Validation Tab.

Paste Special Example 5-4

Shortcut #7 – Paste as Add (ALT + E + S + D)

In the below image, we have values from A2 to A6. For example, we have a value of 6 in cell C2. If we copy cell C2 and select the range of cells from A2:A6, it will add 6 to all the existing values from A2 to A6.

Paste Special Example 6
  • Copy the cell C2
Paste Special Example 6-1
  • Select the range from A2:A6.
Paste Special Example 6-2
  • Press “ALT + E + S + D.”
Paste Special Example 6-3

Now, the result is as per the below image.

Paste Special Example 6-4

Shortcut #8 – Paste as Subtract (ALT + E + S + D)

In cell H5, we have a value of 5.

Example 7

Suppose we copy-paste to subtract the value from F2 to F6. We will get the below result.

  • Copy cell H1
Example 7-1
  • Select the range F2 to F6
Example 7-2
  • Press “ALT + E + S + S.”
Example 7-3

Now, the result is as per the below image.

Example 7-4

Shortcut #9 – Paste as Multiply (ALT + E + S + M)

Look into the below image. We have a value of 10 in cell M1. We have different values in K2 to K6.

Example 8
  • Copy the cell M1.
Example 8-1
  • Select the cells from K2 to K6.
Example 8-2
  • Press “ALT + E + S + M.”
Example 8-3

Now, the result is as per the below image.

Example 8-4

Shortcut #10 – Paste as Divide (ALT + E + S + I)

Consider the same example. We have values in K2 to K6.

Example 9
  • Copy the cell M1
Example 9-1
  • Select the cell K2 to K6.
Example 9-2
  • Press “ALT + E + S + I.”
Example 9-3

It will divide the existing values by 10.

Example 9-4

Paste Special in Excel Video

Recommended Articles

This article is a guide to Paste Special in Excel. We discuss using the different Paste Special options in Excel and Excel examples and downloadable Excel templates. You may also look at these useful functions in Excel: –