# 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?

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.

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?

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

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

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

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

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1