When you're inputting the "=A1" (or whatever reference), you can hit the
F4 key and it will add the $s. Hit it again, and it will move through
all the variations you can have -- i.e. $A1, A$1, A1, $A$1, etc.

If you're inputing a formula like "=A1*A2", immediately after typing
(or clicking the) A1 is when you'd hit the F4 key to add $s to the A1.
After typing (or clicking the) A2, is when you hit the F4 key for it.


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=399616