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

 

To see the full course contents click here.

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