Paste Special- Values, Formulas with/without formatting

Please purchase the course before starting the lesson.

Paste Special- well known options.

By this stage you should be familiar with Copy and Paste. If you do this, everything is copied and pasted.

What if you don’t want to copy everything?

What happens if you don’t want to copy everything in a range. Perhaps you like the way you have formatted the area but don’t want the same text and numbers. Perhaps you want the formulas to be removed but it must leave the results of the formulas behind  as numbers.

Special Paste Options (Paste Special)

Excel has a number of Paste Special options to cater for all your needs.

Copy Paste

Paste Special Formulas

Copy Paste

Paste Special Values

Copy Paste

Paste Special Comments

Copy Paste

Paste Special All Except Borders

Copy Paste

Paste Special Formulas and number formats

Copy Paste

Paste Special Values and number formats

Copy Paste

 

Back to: Intermediate Excel Course > The Specials- GOTO and Paste