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.
Paste Special Formulas
Paste Special Values
Paste Special Comments
Paste Special All Except Borders
Paste Special Formulas and number formats
Paste Special Values and number formats