EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Login
Home Excel Excel Resources Excel Tips Paste Special Shortcut in Excel

Paste Special Shortcut in Excel

Dikshita Jain
Article byDikshita Jain
Madhuri Thakur
Reviewed byMadhuri Thakur

What is Paste Special in Excel?

Paste Special in Excel is a feature that allows you to decide exactly what detail of a value you want to copy and paste from one cell to another.

For example, let’s say you have a value in a cell with a blue background color, and you want to copy only the background color of that value to other cells. You can use Paste Special to do this. There are several other options, like, you can paste only the format, formula, column width, comments, or more.

Shortcuts to open the Paste Special dialog box in Excel for Windows are Alt + E + S or Ctrl + Alt + V. The Paste Special shortcut in Excel for Mac is Ctrl + Cmd + V.

Furthermore, if you want to directly copy-paste values or formats, you can use their respective paste special shortcut in Excel, like Alt + E + S + V for Values and Alt + E + S + T for Formats. We have provided a detailed explanation of these shortcuts in the example section.

ADVERTISEMENT
Popular Course in this category
MS Excel Course Bundle - 36 Courses in 1 | 13 Mock Tests

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Paste special example

Table of Contents
  • What is Paste Special in Excel?
  • How to Access Paste Special in Excel?
  • 10 Paste Special Shortcut in Excel (with examples)
    • Shortcut 1: Paste Values
    • Shortcut 2: Paste Formulas
    • Shortcut 3: Paste Formats
    • Shortcut 4: Paste Transpose
    • Shortcut 5: Paste Comments
    • Shortcut 6: Paste Column Width
    • Shortcut 7: Paste Values and Add
    • Shortcut 8: Paste Values and Subtract
    • Shortcut 9: Paste Values and Multiply
    • Shortcut 10: Paste Values and Divide
  • Snapshot: All 18 Paste Special Shortcut in Excel

Before we tell you about the handy shortcuts for Paste Special operations, let us first see how to use Paste Special in Excel.

How to Access Paste Special in Excel?

There are various ways to access and open Paste Special in Excel. Here are some common methods:

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

Method 1: Keyboard Shortcut (Alt + E + S)

  1. Select the cells you want to copy.
  2. Press Ctrl + C to copy the cells.
  3. Press Alt + E + S on your keyboard.
  4. A dialog box will open with various paste options. Choose the desired option by pressing the corresponding letter key.

Paste Special shortcut in excel

Method 2: Ribbon Menu

  1. Select the cells you want to copy.
  2. Go to the “Home” tab in the Excel ribbon.
  3. Look for the “Clipboard” group.
  4. Click on the arrow in the bottom-right corner of the group.
  5. A menu will appear. Choose “Paste Special“.

Ribbon Menu

Method 3: Right-Click Menu

  1. Select the cells you want to copy.
  2. Right-click on the selected cells.
  3. A context menu will appear. Choose “Paste Special” from the menu.

Paste Special shortcut in excel-Right-Click Menu

10 Paste Special Shortcut in Excel (With Examples)

Shortcut 1: Paste Values

Windows: ALT + E + S + V
Mac: Ctrl + Command + V > Command + V
Purpose: This shortcut allows you to paste only the values from the copied cells without any formatting or formulas.                  

Example: Let us see how to paste special values in Excel.

  • Open your Excel spreadsheet and select the range of cells containing the formulas and values you want to copy.

Paste Values

  • Right-click on the selected range and choose “Copy” or use the shortcut “Ctrl + C” to copy the cells.
  • Now, select the destination where you want to paste the values.
  • Right-click on the destination cell or range, and press Alt + E + S + V. It will directly select “Values” in the Paste Special dialogue box.
  • Click “OK”.

Paste Special shortcut in excel-Paste Values 2

  • Now, Excel will paste only the calculated values from the original range to the destination cells without including the underlying formulas.

Paste Values 3

Shortcut 2: Paste Formulas

Windows: Alt + E + S + F
Mac: Ctrl + Command + V > Command + F
Purpose: This shortcut allows you to paste only the formulas from the copied cells, keeping the cell’s original formatting as it is.     

Example:

Let’s say there are two Stationery shops: Shop A and Shop B. We have information about the products, quantities, and prices for both shops. We have already calculated the total price for each product in Shop A. Now, we want to find the total price for Shop B using the “Paste Special” feature as a formula.

Let’s see how to do it:

  • Copy the cell or range of cells containing the formulas

Paste Formulas 1

  • Select the corresponding column or cell in shop B where you want to apply the formula.

Paste Formulas

  • Press Alt + E + S + F. It will directly select “Formulas” in the Paste Special dialogue box.
  • Click on the “OK” button.

Paste Formulas 3

  • This will copy the formulas used in the Shop A table and paste them into the selected cells in the Shop B table. However, it will not paste the formatting for Shop A, such as color, bold, etc.

Paste Formulas 4

Shortcut 3: Paste Formats

Windows: Alt + E + S + T
Mac: Ctrl + Command + V > Command + T
Purpose: This shortcut copies only the formatting of the selected cells, allowing you to apply it to other cells.                    

Example:

Suppose we have temperature records for two cities: New York and Los Angeles. We have applied color formatting to the New York City table to represent different temperature levels. The three categories we have used are: high, medium, and low. We now need to replicate the same formatting for Los Angeles using Paste Special  Shortcut in Excel for pasting format.

Let’s see how to find it using the Paste Special feature.

  • First, copy the table of New York where the color formatting is already applied.

Paste Formats 1

  • Then, select the entire table of Los Angeles.
  • Press Alt + E + S + T. It will open the Paste Special dialogue box with “Formats” already selected.
  • Finally, click on the “OK” button.

Paste Formats 2

  • The temperature values for Los Angeles will now have the same color formatting as the corresponding values for New York.

Paste Formats 3

Shortcut 4: Paste Transpose

Windows: Alt + E + S + E
Mac: Ctrl + Command + V > Command + E
Purpose: This shortcut quickly swaps rows with columns and columns with rows when pasting data.

Example:

You have a table with data organized in columns but want it to be organized in rows instead. Instead of copying each cell one by one and manually placing it, we will use the Paste Transpose feature to achieve this transformation in a single step. Let’s see how:

  • Select and copy the range of cells that you want to transpose.

Paste Transpose 1

  • Choose the cell where you want the transposed data.
  • Press Alt + E + S + E. It will directly select “Transpose” in the Paste Special dialogue box.
  • Click on the “OK” button to apply the transposition.

Paste Transcope 2

  • The data will be pasted in rows instead of columns, with the values switched accordingly.

Transcope 3

Shortcut 5: Paste Comments

Windows: Alt + E + S + C
Mac: Ctrl + Command + V > Command + C
Purpose: This shortcut pastes only the comments from the copied cells, allowing you to add or replace comments in the destination cells.                      

Example:

We have a sales report with the transaction ids of a few salespersons. We added a comment for one cell and want to duplicate it for another cell without manually rewriting it.

Let’s see how to do that:

  • Select and copy the cell where the comment is present.

Paste Special Shortcut in Excel-Paste Comments 1

  • Now, select the cell where you want to paste the comment.
  • Press Alt + E + S + C. It will automatically select “Comments” in the Paste Special dialog box.
  • Click on the “OK” button to paste the comment.

Paste Special Shortcut in Excel-Comments 2

  • Result will appear as follows:

Paste Special Shortcut in Excel-Paste Comments 3

Shortcut 6: Paste Column Width

Windows: Alt + E + S + W
Mac: Ctrl + Command + V > Command + W
Purpose: This shortcut copies and applies the column widths from one set of cells to another set of cells.

Example:

You have a table with columns for employee name, ID, and location. Each column has specific widths assigned to ensure it looks good and is easy to read. If you copy and paste the table somewhere else, the formatting will stay the same, but it won’t copy the column widths. For that, we will use the “Paste Special” option to copy the column widths.

Let’s find out how to do it:

  • Select and copy the entire table

Width 1

  • Now, select the table where you want to apply the same column structure and widths.

Paste Special Shortcut in Excel-Paste Column Width 2

  • Press Alt + E + S + W. It will directly select “Column Width” in the Paste Special dialogue box.
  • Click on the “OK” button.

Column Width 3

  • Excel will create the second table with the same column structure and widths as the original table, ensuring consistency in formatting.

Paste Special Shortcut in Excel-Column Width 4

Shortcut 7: Paste Values and Add

Windows: Alt + E + S + V + D
Mac: Command + Option + V (Mac), then press V and press A
Purpose: This shortcut allows you to add the value of the copied cell with the values at the destination cell and paste the combined value in the destination cell.                                

Example:

In Example 1, we learned about using Paste Special to copy values. Now, let’s learn how to paste values after adding a specific amount.

Suppose we have a list of employees with their respective salaries, and we want to give each employee a $2000 bonus. Instead of manually adding the bonus to each salary, we can use “Paste Special and add” to quickly calculate the total. It allows us to add a single value to a range of cells without using the SUM function for each cell.

Let us see how we can do this:

  • Select the source cells to copy the values you want to add.

Paste Special shortcut in excel-Paste Values and Add 1

  • Select the destination cells where you want to paste the added values.

Paste Values and Add 2

  • Press Alt + E + S + V + D. It will directly select both “Values” and “Add” in the Paste Special dialogue box.
  • Click on the “OK” button to paste the values with addition.

Paste Special Shortcut in Excel-Add 3

  • The result will show a $2000 bonus added to each employee’s salary.

Paste Values and Add 4

Shortcut 8: Paste Values and Subtract

Windows: Alt + E + S + V + S
Mac: Command + Option + V, then press V and press S
Purpose: This shortcut allows you to subtract the value of the copied cell from the value present in the destination cells.                              

Example:

In Example 6, we saw how to add a particular value in a cell range directly. Similarly, we can also subtract a value from the existing values. Bryn, a salesperson, aims to set aside $500 from his monthly sales. He wants to determine the remaining amount he will have after deducting the savings. Let’s explore how he can use the “paste values” and “subtract” features to calculate this.

  • First, to copy the values you want to subtract, select the cells and press “Ctrl + C”.

Paste Special Shortcut in Excel- Subtract 1

  • Select the destination cells where you want to paste the subtracted values.

Paste Special shortcut in excel-Paste Values and Subtract 2

  • Press Alt + E + S + V + S. It will directly select “Values” and “Subtract” in the Paste Special dialogue box.
  • Click on the “OK” button to paste the values with subtraction.

Subtract 3

  • The result will show $500 subtracted from Bryn’s sale.

Paste Special Shortcut in Excel-Paste Values and Subtract 4

Shortcut 9: Paste Values and Multiply

Windows: Alt + E + S + V + M
Mac: Command + Option + V, then press V and press M
Purpose: This shortcut pastes the values from the copied cells and multiplies them with the existing values in the destination cells.                                   

Example: 

Imagine you have a list of fruits along with their respective prices. You intend to purchase each fruit in a quantity of 6. To determine the total cost of each fruit, you need to multiply the price by the quantity. We will use the “Paste Special” feature to accomplish this.

Let us see how to use paste special multiply in Excel:

  • Copy the cells which have the values you want to multiply.

Multiply 1

  • Select the destination cells where you want to paste the values with multiplication.

Paste Values and Multiply 2

  • Press Alt + E + S + V + M. It will directly select “Values” and “Multiply” in the Paste Special dialogue box.
  • Click on the “OK” button to paste the values with multiplication.

Paste Special Shortcut in Excel-Paste Values and Multiply 3

  • The result will show the total price of each fruit item.

Multiply 4

Shortcut 10: Paste Values and Divide

Windows: Alt + E + S + V +  I
Mac: Command + Option + V, then press V and press D
Purpose: This shortcut pastes the values from the copied cells and divides them by the existing values in the destination cells.

Example:

Imagine you have a list of vegetables and their respective total price. Each vegetable has a quantity of 6. To determine the price per unit for each vegetable, you need to divide the total price by the quantity of 6.

Let’s see how to use paste special divide in Excel:

  • Copy the source cells that contain the values you want to divide.

Paste Special Shortcut in Excel-Paste Values and Divide

  • Select the destination cells where you want to paste the values with division.

 Paste Values and Divide 1

  • Press Alt + E + S + V + I. This will directly select “Values” and “Divide” in the Paste Special dialogue box.
  • Click on the “OK” button to paste the values with the division.

Paste Special Shortcut in Excel-Divide 2

  • The result will show the price of each vegetable.

Paste Values and Divide 3

Snapshot: All 18 Paste Special Shortcut in Excel

Paste Special Shortcuts

Note: If you find it difficult to remember all these shortcuts, don’t worry. Simply check which letter is underlined for that particular option in the dialog box. For example, if you want to check the shortcut key for “Formulas”, you can see that the letter “F” is underlined, meaning it is the shortcut letter.

Paste Special Shortcuts 2

Frequently Asked Questions (FAQs)

Q1. How to enable Paste Special in Excel?
Answer: To enable Paste Special in Excel, follow these steps:

  1. Open your Excel Spreadsheet and click on the “File Menu”.
  2. Select the last feature, “Options”.
  3. Choose the “Advanced” tab from the “Excel Options” dialogue box.
  4. Scroll down to search “Cut, copy, and paste”.
  5. Tick the first checkbox for the “Show Paste Options button when content is pasted”.
  6. Click “OK”.

Q2. What is the difference between Paste and Paste Special in Excel?

Answer: 

Paste in Excel Paste Special in Excel
Inserts copied data as it is. Allows the user to choose how the data should appear.
Limited customization options. More customization options for various data types.
Pastes data with formats, formulas, etc. Selectively pastes elements like values, formats, etc.

Q3. Is Paste Special available in Microsoft Word and Powerpoint too?
Answer: Yes, the “Paste Special” option is available in both Microsoft Word and Powerpoint. The available options are different for both depending on the versions as well.

Recommended Articles

This article is a guide on how to use the Paste Special shortcut in Excel. It includes a comprehensive list of shortcuts for each paste special option and practical examples for your better understanding. You can learn more about Excel from the articles below-

  1. Cheat Sheet of Excel Formulas
  2. SUM Function in Excel
  3. Copy Excel Sheet
  4. Excel Fill Handle
ADVERTISEMENT
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
ADVERTISEMENT
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Paste Special in Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Paste Special in Excel Template

EDUCBA

डाउनलोड Paste Special in Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW