Copy and Paste is one of the most useful tools in Excel. It has some risks but these will be covered later.
Copy and Paste Everything
By default if you copy and paste a cell or cells, Excel will take everything.
This will put that area into a clip board awaiting instructions of where it must go.
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.
This screen will provide all the Paste Special options. For this course we are just working through the red block below.
To see the full course contents click here.