Increase whole column by same percentage

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

Guest

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
 
G

Guest

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
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i increase the value of numbers in a column by a percentage 5
formula to subtract percentage from whole 2
calculating percentage 3
formula? 5
IF formula to get a percentage increase 2
Increasing all values in spreadsheet by same percentage. 1
increase an entire spreadsheet by a percentage 2
How to increase the value of a whole column of cells by a percentage? 1

Top