Download example
paste-special.xls
Description
Paste special is used for only pasting specific information like formulas, numbers only, and performing on the fly addition, subtraction, multiplication, and division.
Alternate Route
Edit > paste special…
[...] all the details here [...]