↑ Return to Manage Data

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.

Shortcut

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.

//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js

2 comments

  1. Anonymous

    old version copy & paste special (value and add) to select paste values and operation add, but in excel 2013 no substitute for this command, if available please email me link to read or give me hint… Thx

  2. Walter

    Your blog is great, thanks for your help!My only complaint is that the videos attached are not showing.

    Greetings from Brazil

    Walter

Leave a Reply

%d bloggers like this: