Paste Special- Values, Formulas with/without formatting
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.
To see the full course contents click here.