You can use Edit/Replace. If the range is fixed it's even better
because there's less risk of hosing something unintentionally. For
range A1:D10
Under Edit/Replace:
Find What = A:
Replace With = $A:
Find What = :D
Replace With = :$D
Or, if the range is fixed for all, then
Find What = A1:D10
Replace with = $A$1:$D$10
--
wmjenner
------------------------------------------------------------------------
wmjenner's Profile:
http://www.excelforum.com/member.php...fo&userid=5282
View this thread:
http://www.excelforum.com/showthread...hreadid=278751