Deducting all numbers in spreadsheet.

[lovelady]

How are all cells in a number only spreadsheet deducted by formula?

For example if all the numbers need a 15% dedection (or multiplied by .85).

 

[PA HS Teacher]

If I understand your question you could either:

enter 0.85 in a blank cell and copy.

Highlight all cells to be "deducted"

Edit, Paste Special, Check Multiply.

Or by formula:
=0.85*A1, Drag as necessary.

Copy the newly pasted cells,

Highlight the original cells

Edit, Paste Special, Check Values

Delete the =0.85*A1 cells if desired.

 

[VoG]

Hello and welcome to MrExcel.

Try this. Type 0.85 into a spare cell then copy it. Select the numbers that you want to change, Edit > Paste Special, tick Multiply and click OK.

 

[lovelady]

Understood. Thank you all for your informative responses.

Glenn
(Lovelady Diamond)