Paste Special in Excel 2000

[LPS]

Can anyone describe, in simple terms, what the "Operation" feature under
"Paste Special" is for (in Excel 2000)? I have tried using the "Add",
"Subtract", etc. operators but seem to get nonsensical results. I cannot
figure out what the purpose of this feature is, but would love to know.

Many thanks for any help.

 

[Gord Dibben]

Enter 10 in a cell.

Copy that cell.

Select a cell or range of cells and Paste Special>Add>OK>Esc to add 10 to each
cell in the range.

Same for divide, subtract, multiply.

Note: these functions operate only on numeric data.


Gord Dibben MS Excel MVP