This is a useful facility when copying data.
Paste Special allows the user to decide exactly how they want to paste the copied information into its new location.
For example, if the information to be copied contains Bold and Underline formatting, the user may not want the text to be formatted in the same way when it is pasted.
Alternatively, the user may have a formula in the section to be copied, but may want the actual value to be pasted rather than the formula.
Once the information required has been copied, select the area to where it is to be pasted, right click and choose paste special.
The following menu will appear:
Paste All
Will paste the copied information exactly as is it.
Paste Formulas
Will paste the formulas contained within the copied information, without any other formatting.
Paste Values
Will paste the values resulting from any formulas contained within the copied information without any other formatting.