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…