How to add 6% to entire sheet?

  • Thread starter Thread starter skeetley
  • Start date Start date
S

skeetley

I have a spreadsheet and I want to add 6% to whatever value is already
in each cell. How does a guy do this?
 
Hi "skeetley"

Make sure that you save a backup.

To my mind it's probably best to copy your table of data to a new
sheet.

Put 1.06 in a cell
Select that cell
Copy
Select the data to be uplifted
Paste Special > Multiply > OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi

Enter 1,06 onto some free cell and copy it;
Select the range with your data, and then PasteSpecial.Multiply
 
Back
Top