Increase whole column by same percentage
 

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.

Increase whole column by same percentage
 

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"jonilyn" wrote:

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.

Increase whole column by same percentage
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jonilyn" wrote:
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.

Increase whole column by same percentage
 

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!

"jonilyn" wrote:

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.