selecting correct paste option

[rich_cirillo]

Good day

When selecting a cell and then use the COPY feature there are many options to select from - Paste,Paste Values,Paste Special,Transpose etc..etc.. many options....how do you know which is the correct option or does someone have a link which explains how each works

Cheers

Rich

Excel 2010

 

[Firefly2012]

Hi Rich

It depends on what you want to do - see if the following helps explain (it refers to the Paste Options button but the contents are applicable to Edit>PasteSpecial)

How to use the Paste Options button in Excel

 

[rich_cirillo]

Thanks firefly2012