Need to add 5% to many rows

R

rgloverd

Hi,
I need to add 5% to the current value of each cell and put the resul
in the same cell. Is there an easy way of doing this?
Thanks,
Richar
 
B

BenjieLop

STEPS:

In any unused cell, enter 1.05
Go to this unused cell and copy (Ctrl-C)
Highlight the range that you want to increase by 5%
Go to Edit/Paste Special/Multiply

Hope this will help you.

Regards.
 
Top