Examples of Paste Special (All Options)

Examples of Paste Special (All Options)
Last Updated on 18/04/2024
Reading time: 2 minutes

Principle of paste special

Once the "copy" has been activated, you can display a specific dialog box that offers a wide range of paste options. To select Paste Special, click on the arrow under the Paste icon and then on the Paste Special option at the bottom.

Menu Paste Special

And the following dialog box appears.

Dialog Box Paste Special

Let's see in this article what is the purpose of each one of these options.

Paste Special FORMULA

This option is useful to keep the formatting of your documents. When you copy your formulas, you keep the formatting of each cell. It's the best solution to not destroy colors or borders style.

Paste Special VALUE

When you use Excel's random functions or the TRIM function to remove spaces in a string, you don't want to keep the formula. You only want to keep the formula's result.

So in that case, you can use the option Paste Special in Value to convert the formula to its result in a cell

Paste in value

Option OPERATION

This option is not the most popular but is very useful when you have to apply a basic calculation to a huge range of cells.

For instance, if you want to divide all your data by 100 (for a percentage for instance) or by 1000 (to display your figure in $K).

It is also very useful to convert whole numbers to hours 😍😎

Option TRANSPOSE

This option allows you to change the orientation of a table from column to row (or the other way round).

The best example to use this option is to convert a calendar with dates in the columns and to one with dates in the rows.

Option Skip Blank

If you have to update only few cells inside a list of data, this option is very useful and will save a lot of time.

Shortcuts

Ctrl + Alt + VTo open the Paste Special dialog box
Ctrl + Shift + VPaste in Value what you have copied
Dialog Box Paste Special

Then, you press the letter corresponding to one of the underlined letters to enable this option, like F, to paste the formula only.

Leave a Reply

Your email address will not be published. Required fields are marked *

Examples of Paste Special (All Options)

Reading time: 2 minutes
Last Updated on 18/04/2024

Principle of paste special

Once the "copy" has been activated, you can display a specific dialog box that offers a wide range of paste options. To select Paste Special, click on the arrow under the Paste icon and then on the Paste Special option at the bottom.

Menu Paste Special

And the following dialog box appears.

Dialog Box Paste Special

Let's see in this article what is the purpose of each one of these options.

Paste Special FORMULA

This option is useful to keep the formatting of your documents. When you copy your formulas, you keep the formatting of each cell. It's the best solution to not destroy colors or borders style.

Paste Special VALUE

When you use Excel's random functions or the TRIM function to remove spaces in a string, you don't want to keep the formula. You only want to keep the formula's result.

So in that case, you can use the option Paste Special in Value to convert the formula to its result in a cell

Paste in value

Option OPERATION

This option is not the most popular but is very useful when you have to apply a basic calculation to a huge range of cells.

For instance, if you want to divide all your data by 100 (for a percentage for instance) or by 1000 (to display your figure in $K).

It is also very useful to convert whole numbers to hours 😍😎

Option TRANSPOSE

This option allows you to change the orientation of a table from column to row (or the other way round).

The best example to use this option is to convert a calendar with dates in the columns and to one with dates in the rows.

Option Skip Blank

If you have to update only few cells inside a list of data, this option is very useful and will save a lot of time.

Shortcuts

Ctrl + Alt + VTo open the Paste Special dialog box
Ctrl + Shift + VPaste in Value what you have copied
Dialog Box Paste Special

Then, you press the letter corresponding to one of the underlined letters to enable this option, like F, to paste the formula only.

Leave a Reply

Your email address will not be published. Required fields are marked *