Paste Special

There are situations where a standard copy / paste is not appropriate. Fortunately, Excel offers a comprehensive range of copy / paste called "special" to make all kinds of recopies.

Principle of paste special



Once the "copy" has been activated, you can display a specific dialog box that offers a wide range of collages. To enable this option, you must click on the arrow under the Paste icon and you're at the bottom of this list the Paste Special option




And the following dialog box appears.

You select one of these options in this dialog box and you validate to apply the special paste.


You can display the same dialog with the shortcut key combination (all versions)

Alt + e then s

With Excel 2007, Excel 2010 and Excel 2013

Alt + Ctrl + v

Then you press the letter corresponding to one of the underlined letters to enable this option (for example, if you want to enable the option value, simply press the V key)

Paste Special FORMULA

This option is useful to keep the formatting of your documents. Watch the video to understand how to use it

Paste Special VALUE



You will be using this option when you want to keep the result of a function but keep the formula. The video attached is going to present two very practical examples with the TRIM function and RANDBETWEEN






Paste Special OPERATION


You can use the Paste Special option to do a basic calculation on a range of cells. For instance, in this example, I will divide all the data by 24.







Paste Special Skip Blank

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


Paste Special TRANSPOSE

This option allows you to redirect data online, in column (and vice versa). The only requirement is to copy the data in the same worksheet. Look at the example in the video.

Permanent link to this article: https://www.excel-exercise.com/paste-special/

Leave a Reply

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