How do you add a constant number to a group of cells?

[Guest]

I have a basic spreadsheet with different rates in each cell. I want to be able to add 2% to each of the rates in the cells. Is there a faster way to do this other than manually entering the 2% increase to each individual cell? Thanks for your help.

 

[Niek Otten]

In an empty cell, enter the number 1.02
Edit>Copy
Select your target cells, Edit>Paste Special, check Multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

I have a basic spreadsheet with different rates in each cell. I want to

be able to add 2% to each of the rates in the cells. Is there a faster way
to do this other than manually entering the 2% increase to each individual
cell? Thanks for your help.

 

[RagDyeR]

Enter 1.02 into a cell.
Right click and choose "Copy".

Now, select the cells that you wish to increase.
Right click in the selection and choose
"PasteSpecial"
Click "multiply"
Then <OK>
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a basic spreadsheet with different rates in each cell. I want to be
able to add 2% to each of the rates in the cells. Is there a faster way to
do this other than manually entering the 2% increase to each individual
cell? Thanks for your help.