Dragging Formulas

[Jeff Podgorski]

Hello,

I'm dragging a formula down in my spreadsheet ='[Weekly Cost Tracking 2011.xlsm]Labor Cost'!$AI$491, I need the column to change to AJ but the row desigantion of 491 to remain.

I'm sure this is easy, thanks for the help.

Jeff

 

[GK039]

Tap F4 until the dollar sign is removed in front of AI. It should then be AJ$491. But you have to drag it to the right

George

Hello,

I'm dragging a formula down in my spreadsheet ='[Weekly Cost Tracking 2011.xlsm]Labor Cost'!$AI$491, I need the column to change to AJ but the row desigantion of 491 to remain.

I'm sure this is easy, thanks for the help.

Jeff

 

[Jeff Podgorski]

No way to drag it down in my spreadsheet and have it move across in the referenced spreadsheet?

Tap F4 until the dollar sign is removed in front of AI. It should then be AJ$491. But you have to drag it to the right

George

 

[GK039]

If you're using absolute reference (that is with the dollar sign) you cant go both ways, down and to the right and change the cell references. You have to use a mixed reference

No way to drag it down in my spreadsheet and have it move across in the referenced spreadsheet?