How to increase a salary sheet by a set percentage in all cells?

[Guest]

I am working on a salary proposal for a teachers contract. I have last years
sheet. I want to be able to increase each of the cells lets say by 3%. What
do I need to do? In addition I would also like to create a sheet that shows
the percentage each cell has increases. This is important as there have been
gaps in steps across and down. I believe there is a way but it appears to be
out of my league. So the first printout would show the new salary schedule
with the 3% increase and the second printout will show how much each cell
increase by percentage. I appreciate any help I can get. Thanks.

 

[paul.robinson]

Hi
for your first question:
"am working on a salary proposal for a teachers contract. I have
last years
sheet. I want to be able to increase each of the cells lets say by
3%. What
do I need to do?"
Create a copy of the sheet (right click the sheet Tab at the bottom,
click on Move or Copy...in the dialog box tick the "Create a Copy" box
and decide where you want the sheet to be).
For each cell you want to increase by 3% go to the cell in the copy
and type

=1.03*

then click on the same cell in the original sheet (if it was cell B3
on Sheet1 you will now have = 1.03*Sheet1!B3) and press return.
You can copy this formula to your other cells.
If you don't want a formula in the cells, select everything on the
copy sheet with the mouse and do Edit, Copy then (without changing the
selection) do Edit, Paste Special..., and choose Values. All your
formulas will disappear and you will be left with the values. You can
delete the original sheet if you want.

"In addition I would also like to create a sheet that shows
the percentage each cell has increases. This is important as there
have been
gaps in steps across and down."

No idea what this second question means, as I can't see what you are
looking at "across and down"???

regards
Paul