Introduction
Paste special options let you paste copied data in different ways. You can choose to paste only values, formulas, formatting, or other parts. This helps when you want to keep some parts of the data but not others.
When you want to paste only the numbers without the original colors or fonts
When you want to copy a formula but keep the destination cell's formatting
When you want to paste only the formatting from one cell to another
When you want to add or subtract numbers by pasting with a math operation
When you want to transpose rows into columns or columns into rows