As I said, as soon as you are entering any part of any formula press the F4
key before moving on or re-select the reference and press F4

Repetitive presses toggles through the four options (In no particular order)

Absolute Row, Absolute Column
Relative Row, Absolute Column
Absolute Row, Relative Column
Relative Row, Relative Column

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"dallased25" wrote
in message ...

Awesome, thanks for the info! One more question though. Is there a way
to make it so that it puts the $ in there automatically the first time
around, rather than me having to go in there everytime and edit the
formula?


--
dallased25
------------------------------------------------------------------------
dallased25's Profile:
http://www.excelforum.com/member.php...o&userid=28544
View this thread: http://www.excelforum.com/showthread...hreadid=482033