Paste Special in Excel (With Top 10 Shortcuts)

Paste special in excel means when we want to paste only some aspects of the data rather than the original data we use this option, there are various methods to paste special in excel and they are by right click on the target cell and select paste special or by keyboard shortcut as CTRL + ALT + V or we can press ALT + E + S, to use the aspects we can use the Excel shorcut of paste values we can press ALT + E + S + V for values only.

Paste Special in Excel

Sometimes in Excel, you need to perform some very real quick things. Sometimes we need to copy a cell or range of cells to some other cells or range of cells along with formatting, along with formulas etc… Also, we need to copy & paste only values without bringing anything else along with it. Take a look into the below image.

Paste Special

Paste Special shortcut

In general, what happens if you copy a cell and paste? Look into the below image.

Paste Special 1

When you copy the above image value and paste in another cell, it copies the entire thing that is 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.… along with it.

Paste Special 2

Top 10 Paste Special Shortcuts

Below are some of the Shortcuts that will save your lot of time.

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 when you copy the cell, it copies everything associated with it. Now we look into the Paste as Values example.

Look into the below image in cell A2 to A4 we have number 15 in cell A5 we applied SUM formula. Suppose we copy cell A5 and paste in C5 what happens. In a general scenario, we should get the value of 15 only right? But, we will get the value of 30. One notable thing is it changes the colour 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 2 cells to the right, i.e. column C, now it will take the reference as C2:C4 and do the summation of 10+10+10 = 30.

Paste Special Example 1-1

Now the requirement is I want to copy the cell A5 and paste in cell B8 without altering the cell of B8. We should get the value of 45, and cell colour should be blue only.

Steps to Copy and Paste only Values.

  • Copy the cell A5.

Paste Special Example 1-2

  • Go to B8.

Paste Special Example 1-3

  • Press ALT + E + S it will open the below dialogue box.

Paste Special Example 1-4

  • To select the values press V.
  • Now we get the value of 45 in cell 45 without changing the cell B8.

Paste Special Example 1-5

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

Look into the below image, in cell A5 SUM formula is applied. I want to copy the formula from that cell and paste in the cell C5 without changing the colour of the cell. Even if you just copy and paste, you will get the result, but it will change the colour of the cell C5. To avoid that we use Paste as Formulas.

Paste Special Example 2

Now, copy the cell A5 and 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 below image, we need to copy the cell A5 which contains the formula, but we need to paste only the format of the cell 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 below one.

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. 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 to 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 below one.

Paste Special Example 4-3

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

We can paste the values, we can paste the formulas, we can paste the format, and similarly, we can paste the Validation too.

Look into the below image where we have validation of YES & 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 the cell C1

Paste Special Example 5-1

Press ALT + E + S + N.

Paste Special Example 5-2

Now the result will be like the below one.

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, and we have a value of 6 in cells C2. If we copy the 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

And if we copy paste as Subtract the value to 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 the 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 has been a guide to Paste Special in Excel. Here we discuss how to use the different types of Paste Special Options in Excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

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