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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

series of sums in a long spreadsheet 1
problem with fractions to decimal 1
add or subtract every 5th column 2
Year to date totals 2
How to sort entire spreadsheet by one column sort 5
Summing a Variable Number of Cells 1
Totals in one cell 6
Worksheet Formula Links 1

Back
Top