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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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

kclpuma said:
I have a basic spreadsheet with different rates in each cell. I want to
Click to expand...
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.
 
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.
 
Back
Top