# How can I change the entire column by the same percentage?

1. ## How can I change the entire column by the same percentage?

I have a column (G2:G128). Each one of the fields in this column have a number. I want to reduce each one of the numbers in the fields by 25%.
What is the formula that I need to use to make this happen?  Register To Reply

2. ## Re: How can I change the entire column by the same percentage?

An array formula is easiest. Percentages are also numbers so select where you want the result(say H2:H128) and type "=G2:G128*0.75" and use Ctrl+Shift+Enter to enter the formula.  Register To Reply

3. ## Re: How can I change the entire column by the same percentage?

That doesn't quite give me the results that I'm looking for. I tried doing what you recommended however that solution gives the results in a new column. I have to keep the data in the same column. Any way to do that?  Register To Reply

4. ## Re: How can I change the entire column by the same percentage?

Oh... I see. Well assuming that the column in question does not contain any formulas - do as said and then just copy the new column to the old one and choose to paste only the values and then delete it.
If however it does contain formulas then its even easier - multiply the whole formula by your percentage (0.75 in your case).  Register To Reply

5. ## Re: How can I change the entire column by the same percentage?

Enter 0.75 in a cell. Copy that cell.

Then select all the cells of interest, and do Edit > Paste Special, and tick Multiply and Values  Register To Reply

6. ## Re: How can I change the entire column by the same percentage?

Heh... I never knew that trick. Thanks here too. :P  Register To Reply

7. ## Re: How can I change the entire column by the same percentage?

If you need change that value from time to time best way is to put it in some cell (e.g. D1) and in new column (e.g. H) do calculation

\$D\$1*G2 and extend to H128  Register To Reply