Increase whole column by same percentage

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

Guest

How do I increase a whole column of figures by the same percentage. The only
way I know is to multiply the first figure by what I want and copy and paste
the rest of the way down.
 
Assume you want to increase all the numbers by 10%. Enter 1.1 in a blank
cell. Copy it. Then select the entire range in question. Select Paste
Special--Multiply and click OK.

Dave
 
One way ..

Suppose you want to increase by 10%.
Enter 1.1 in any empty cell. Copy the cell.
Then right-click on the col of numbers, choose Paste Special > Mulitply > OK
 
Thank you - I knew there must be an easy way. I'll need to run the numbers
using different percentages so this will work great. Thanks again!
 
Back
Top