filling formulas in a column

radleyboo

Board Regular
Joined
Jul 18, 2008
Messages
51
i am trying to fill a column with this formula which is in the first cell of the column (H6), =G6/G36.

when i try to fill down, both cell references increase by one, =G6/G36, =G7/G37, =G8/G38, etc.

i want the first cell reference (G6) to increase by one cell (G7, G8, G9, etc.) and the second cell reference to remain as G36.

i need to do this for 4 columns of 40 rows and i really don't want to edit the formulas manually.

any clue how i can do this?

thanks,
russ
 
Last edited:

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Mr_Roscoe

Board Regular
Joined
Mar 28, 2006
Messages
200
radley - easy peasy mate.

just insert a $ symbol to anchor that pasrt of the formula.

so (H6) =G6/G$36

cheers, Ian R.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,491
Messages
5,468,914
Members
406,620
Latest member
Gitani123

This Week's Hot Topics

Top