## What Is Paste Special In Excel?

Paste Special in Excelis a feature that enables one to paste the required data of the copied cells. It also offers options to perform arithmetic operations with the copied data.The Excel

Paste Specialshortcut isAlt+E+S, followed by the letters to pick the required options. It will control how the pasted content should appear or function in spreadsheets.

For example, the table below contains a column of data, with the column width being **17.73**.

Suppose the requirement is to set the width of column C the same as that of cell **A1**. Then, we can use the **Column widths **option in the **Paste Special feature in Excel** to achieve the desired outcome.

In the above example, select cell **A1** and press **Ctrl **+ **C **to copy the cell. And then, apply the **Paste Special in Excel shortcut** for the **Column widths** option, **Alt** + **E** + **S** + **W** + **Enter**.

The above steps will open the **Paste Special** dialog box, here, choose the **Column** **widths** option, and set column C width as **17.73**, the cell A1 width.

##### Table of contents

- What Is Paste Special In Excel?
- List of Top 10 Excel Shortcuts
- Shortcut #1 – Paste Special as All
- Shortcut #2 – Paste Special as Formulas
- Shortcut #3 – Paste Special as Values
- Shortcut #4 – Paste Special as Formats
- Shortcut #5 – Paste Special as Comments
- Shortcut #6 – Paste Special as Validation
- Shortcut #7 – Paste Special as Add
- Shortcut #8 – Paste Special as Subtract
- Shortcut #9 – Paste Special as Multiply
- Shortcut #10 – Paste Special as Divide

- Download Template
- Recommended Articles

- List of Top 10 Excel Shortcuts

### List of Top 10 Excel Shortcuts

The **Paste Special feature in Excel** provides various formatting and calculation options. The following are the top ten options, along with their Excel shortcuts.

**Paste Special as All.****Paste Special as Formulas.****Paste Special as Values.****Paste Special as Formats.****Paste Special as Comments.****Paste Special as Validation.****Paste Special as Add.****Paste Special as Subtract.****Paste Special as Multiply.****Paste Special as Divide.**

#### Shortcut #1 – Paste Special as All

**Description**

The **All** option in the **Paste Special **feature helps paste the copied cell data, including the applied formatting. Thus, it is equivalent to the **Paste** option, which we typically use to paste data.

The **Paste Special in Excel** **shortcut** to access the **All** option is **Alt **+ **E** + **S** + **A**.

**Example Scenario**

The first table contains two values and the modulo using the **MOD()**.

Suppose the requirement is to determine the modulo of the number and divisor given in the second table and display the result in cell C5, which has no format.

**Solution**

**Step 1:**Select cell**C2**, and press the excel keyboard shortcut**Ctrl**+**C**to copy the cell formula and format.

**Step 2:**Select the target cell**C5**, press the keyboard shortcut**Alt**+**E**+**S**+**A**to open the**Paste Special**window, and choose the**All**option.

Finally, click **OK** to close the dialog box, and we will see the **MOD()** output in cell **C5** with the updated cell references. The copied cell **C2** format gets applied in cell **C5** (The cell data is **Bold**, and the cell has borders on all sides).

#### Shortcut #2 – Paste Special as Formulas

**Description**

The **Formulas** option in **Paste Special **in Excel enables one to paste the formula from the copied cell to the target cell without the formatting. The Excel shortcut to access this option is **Alt **+ **E** + **S** + **F**.

**Example Scenario**

The below tables contain a few celebrity quotes in the dataset.

Cells **D2:D3** show the corresponding columns A and B cells’ texts concatenated, but the formulas in the two cells are slightly different.

The requirement is to use cell **D2**’s formula to display the concatenated text in cell **D6**.

**Solution**

The **Formulas** option from the feature **Paste Special **in Excel can help us to copy the formula from the source cell and paste it into the target cell.

**Step 1:**Select cell**D2,**and press the keys**Ctrl**+**C**to copy the cell formulas.

**Step 2:**Select the target cell**D6**, press the keyboard shortcut**Alt**+**E**+**S**+**F**to open the**Paste Special**window, and choose the**Formulas**option.

Finally, click **OK** to view the required formula applied in cell **D6**.

The cell references in the copied formula get updated in the target cell. But cell **D2** format is not applied in the target cell **D6**.

#### Shortcut #3 – Paste Special as Values

**Description**

The **Values** option helps make the best **use of Paste Special in Excel**. Using it, we can paste only the value from the copied cell, without the formula and formatting, into the target cell.

The keyboard shortcut to access the **Values** option is **Alt** + **E** + **S** + **V**.

**Example Scenario**

The first table contains the **PMT excel formula** inputs.

We use the given data to calculate the annual payments we must make towards the loan amount of $50,000, using the **PMT()** in cell C8 as **$12,194.53**. The value font is red and within brackets (negative value), as it is an outgoing amount.

The requirement is to display the **PMT()** output in the target cell C10 without the formula.

**Solution**

**Step 1:**Select cell**C8**, and press the keys**Ctrl**+**C**to copy the cell content.

**Step 2:**Select the target cell**C10**, press the keyboard shortcut**Alt**+**E**+**S**+**V**to open the**Paste Special**window, and choose the**Values**option.

Click **OK**, to close the window. We will see only the required annual payment value pasted in the target cell without the formula and cell or data formatting.

#### Shortcut #4 – Paste Special as Formats

**Description**

Another practical **use of Paste Special in Excel** is the **Formats **option. It allows users to paste the copied cell’s format without the cell value or formula in the paste area.

The keyboard shortcut to use the **Formats** option from the **Paste Special** window is **Alt** + **E** + **S** + **T**.

**Example Scenario**

The first table contains Inventory A details.

The requirement is to create a table for Inventory B with the same format as the first table. Assume the target columns are **G:I.**

**Solution**

**Step 1:**Select the cell range**A2:C11**, and press**Ctrl**+**C**to copy the cells.

**Step 2:**Select the first cell in the target cell range,**G2**, press the keyboard shortcut**Alt**+**E**+**S**+**T**to open the**Paste Special**window, and choose the**Formats**option.

Click **OK**, to close the **Paste Special** window. We will see the source cells’ format copied in the target cell range **G2:I11**.

The column headers (cells **A2:C2 **and** G2:I2**) in the two tables have the same format. And as required, the cell range **I2:I11** has the **Date** format. The reason is that the corresponding source cells **C3:C11** have the **Date** format.

So, the **Formats** option helps paste the cell and its content format in the target cell.

#### Shortcut #5 – Paste Special as Comments

**Description**

The **Comments** option in **Paste Special **in Excel allows pasting only the comments from the copied cells to the target cells. It does not paste the cells’ data, formats, or formulas.

The keyboard shortcut to apply the **Comments** option is **Alt **+ **E **+ **S** + **C**.

**Example Scenario**

Suppose there are two tables containing Teams A and B employee lists. And the cells in the first table show comments.

The requirement is to copy and paste the first table comments into the corresponding cells for the Team B employees in the second table.

**Solution**

First, we must select each source cell and use the option in the **Review** tab (highlighted in the image below) to hide the comment. It will ensure that the comment will be visible only when placing the cursor on the concerned cell.

**Step 1:**Select the cell range**A2:A11**, and press the keys**Ctrl**+**C**to copy the cells.

**Step 2:**Select the target cell range**C2:C11,**press the keyboard shortcut**Alt**+**E**+**S**+**C**to open the**Paste Special**window, and choose the**Comments**option.

Click **OK**, to close the window. We can view the target cells with the comments copied from the first table.

We can use the highlighted option in the **Review** tab to show all comments for verification.

The above result shows that the Team B Employees list data remains the same but gets updated with only the copied comments from the first table.

#### Shortcut #6 – Paste Special as Validation

**Description**

The **Validation** option in **Paste Special **in Excel helps paste the **excel Data Validation** configurations from copied cells to the target cells.

The keyboard shortcut to use the **Validation** option from the **Paste Special** window is **Alt** + **E** + **S** + **N**.

**Example Scenario**

The table below contains the customer feedback criteria in column A and rating options in column B cells.

Suppose cells **B2 **and** B3** have the validation setting (Using the **Data Validation** option in the **Data** tab) to enable a customer to choose the ratings.

The requirement is to copy the two validation settings and paste them into cells B4:B5 in the same order.

**Solution**

**Step 1:**Select cells**B2:B3**, and press the keys**Ctrl**+**C**to copy the cells.

**Step 2:**Select the first cell in the target cell range,**B4**, press the shortcut keys**Alt**+**E**+**S**+**N**to open the**Paste Special**window, and pick the**Validation**option.

Click **OK**, to close the dialog box. The copied validation configurations from cells **B2 **and** B3** will get pasted in the target cells **B4 **and** B5**, respectively.

#### Shortcut #7 – Paste Special as Add

**Description**

The **Add** option in **Paste Special **in Excel adds the copied cell value to the target cell data. The keyboard shortcut to access the **Add** option is **Alt** + **E** + **S** + **D**.

**Example Scenario**

The below table contains the students’ scores in Mathematics.

The requirement is to add the project credits, **20**, to the mathematics scores in column B.

**Solution**

**Step 1:**Select cell**E1**, and press the keys**Ctrl**+**C**to copy the cell content.

**Step 2:**Select the target cells**B2:B11**, press the keyboard shortcut**Alt**+**E**+**S**+**D**to open the**Paste Special**window, and pick the**Add**option.

Click **OK**, to close the dialog box. We can view the updated scores of each student in column B, which is the sum of the specified Mathematic score out of 80 and project marks.

**Step 3:**Update the column B title to suit the revised total Mathematics scores.

#### Shortcut #8 – Paste Special as Subtract

**Description**

The **Subtract** option in **Paste Special **in Excel subtracts the copied cell value from the target cell data. The keyboard shortcut to access the **Subtract** option is **Alt** + **E** + **S** + **S**.

**Example Scenario**

The following table shows a list of stocks and their prices.

The requirement is to deduct the amount by which the stock prices dropped, **$50**, from the stock prices in column B.

**Solution**

**Step 1:**Select cell**E1**, and press**Ctrl**+**C**to copy the cell value.

**Step 2:**Select the target cells**B2:B11**, press the keyboard shortcut**Alt**+**E**+**S**+**S**to open the**Paste Special**window, and pick the**Subtract**option.

Click **OK**, to close the window. We will see the cell **E1** value of **$50** subtracted from each stock price in column B.

**Step 3:**Update the column B title to suit the revised stock prices.

#### Shortcut #9 – Paste Special as Multiply

**Description**

The **Multiply** option in **Paste Special **in Excel multiplies the target cell values by the copied cell data. The keyboard shortcut for accessing the **Multiply** option is **Alt** + **E** + **S** + **M**.

**Example Scenario**

The below table shows the results of four experiment trials.

The requirement is to multiply the trial results in column B with the specified multiplication factors in the same order and show the updated values in column B.

**Solution**

**Step 1:**Select cells**E1:E2**, and press the keys**Ctrl**+**C**to copy the cell values.

**Step 2:**Select the target cells**B2:B5**, press the keyboard shortcut keys**Alt**+**E**+**S**+**M**to open the**Paste Special**window, and choose the**Multiply**option.

Click **OK**, to close the **Paste Special** window and to view the updated results after multiplying the trial results by the respective multiplication factors in the specified order.

**Step 3:**Update the column title to suit the updated trial results.

#### Shortcut #10 – Paste Special as Divide

**Description**

The **Divide** option in **Paste Special **in Excel divides the target cell values by the copied cell data. The keyboard shortcut for accessing the **Divide** option is **Alt** + **E** + **S** + **I**.

**Example Scenario**

The below table contains a list of products and their prices.

Assume the specified prices are incorrect, and we must rectify the price values by dividing them by the correction factor.

**Solution**

**Step 1:**Select cell**E1,**and press**Ctrl**+**C**to copy the cell content.

**Step 2:**Select the target cells**B2:B6,**press the keyboard shortcut keys**Alt**+**E**+**S**+**I**to open the**Paste Special**window, and choose the**Divide**option.

Click **OK**, to close the window. We can view the corrected prices in column B.

Each price value gets divided by the correction factor, **$10**.

**Step 3:**Update the column B title to suit the corrected price values.

The above four examples show that the target cells contain the values and not the respective formulas we applied using the **Paste Special** options.

It is not a case of **Paste Special not working in Excel**. Instead, the **Paste Special** feature helps perform the arithmetic operations on a cell range without using additional columns. Also, the result in the paste area has the same number format as the copied cell data.

On the other hand, we may face the scenario of the **Paste Special not working in Excel** if we have the **Paste Special** feature disabled. Otherwise, we have third-party add-ins in Excel, which conflict with the **Paste Special** options.

### Download Template

This article must help understand the **Paste Special In Excel**, with its formula and examples. You can download the template here to use it instantly.

### Recommended Articles

This has been a guide to Paste Special in Excel. Here we learn about top 10 excel shortcuts to paste data, along with examples & downloadable excel template. You can learn more from the following articles –

## Leave a Reply