Automatically making the references absolute is not possible AFAIK. However,
if the formulae you've copied are then unchanged, if you select the
absolutes in the first formula, then copy it.....

Forgive me if you already know this but $A$1 will remain the same, $A1 will
change row numbers with copying and A$1 will change columns.

--
Ian
--
"guilbj2" wrote in
message ...

Sorry, total newb question here but I lack the proper vocabulary so I'm
having a difficult time finding this answer in help or online. I have
several rather lengthy formulas that I've already entered. After
entering them, I've found I've made something of a major error in not
including the $ sign in front of the cell references. I now need to
copy the formulas and the auto re-assignment of the cell references is
just killing me. Editing them all manually will take ages. Is there
any way to automatically add the $ sign to all cell references in an
existing formula?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile:
http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=466761