How to copy while holding one reference constant?

[gshock]

I'm not even sure how to describe this. But here goes. Suppose I have a formula =D$17/2, and I want to copy that to a range of cells in that column. When I copy that formula down the column, it doesn't index the column reference "D". I thought for sure that there was a way to do this, but I can't, for the life of me, remember how to do it. Basically, as I copy the formula down, I want it to index cells across the spreadsheet.

Anyone know how to do this? I don't want to edit every single cell manually.

Thanks,

-gshock

[Charles]

gshock,


Something like this: =$D$17/2. To keep "D" and values
Or:
=$D17/2 to increment 17 to 18 when formula copied down.

[shg]

You could use =INDEX($D$17:$IV$17, 1, ROW() - 17) / 2

Adjust the constant for the row in which the formula first appears (it's correct for row 18 as shown).

[gshock]

gshock,


Something like this: =$D$17/2. To keep "D" and values
Or:
=$D17/2 to increment 17 to 18 when formula copied down.

Charles,

Thanks for the suggestion. Actually, I want to do the reverse. I want to increment "D" while keeping 17 constant.

I found a way to do what I need. I used the OFFSET command to index the cell, and it worked well. I had forgotten all about it.

[gshock]

You could use =INDEX($D$17:$IV$17, 1, ROW() - 17) / 2

Adjust the constant for the row in which the formula first appears (it's correct for row 18 as shown).

shg,

Thanks for the tip. I haven't used the INDEX command before so I'll have to play with it and see how it works. But that might be a good one to use too. Thanks for the help.

-gshock