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)
With Excel 2007, Excel 2010 and Excel 2013
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.