Hi all-

I'm not sure if I'm using the correct terminology but if you have a
cell link that says

=A1 and you copy and scroll that down the cells below it will move as
well...i.e.

=B1
=C1 etc, etc.

Now I know that if you put =$A$1 thhe copy will instead put the $A$1
all the way down which is what I want. If I already have a cell with
30 links that don't have the "$" signs and would like to "hard code"
all the forumlas with the dollar sign is there a shortcut for that? I
seem to remember all you had to do was go to the cell and hit some
shortcut keys and excel would do it for you. Can't recall how that was
done though. Thanks!

Darrell


--
darrelly
------------------------------------------------------------------------
darrelly's Profile: http://www.excelforum.com/member.php...o&userid=27899
View this thread: http://www.excelforum.com/showthread...hreadid=474266