How to increase the value of a whole column of cells by a percentage?

C

colincurious

I am sure this will be fairly straightforward but not immediately
obvious to me. I think it should be!

How would I increase the values of a whole column of cells by a
percentage?

e.g. I want to change the values in cells A1 .. A200 by increasing them
all by 20%?

Thanks
 
G

Gord Dibben

Enter 1.2 in an unused cell.

Copy that cell.

Select A1:A200 and Edit>Paste Special>Multiply>OK>Esc.

Clear the cell with the 1.2


Gord Dibben MS Excel MVP
 

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
Percentage Increase 11
complicated excel formula may need an algebra wiz 1
increase an entire spreadsheet by a percentage 2
Increasing all values in spreadsheet by same percentage. 1
Decimal/Percentage to Whole Number 4
Crazy Variance Formula 0

Top