locking cell references $

[charsea]

i need to lock all my cell references in a long list of formulas. can
do this without typing in $ before each value

 

[Zack Barresse]

Hi charsea,

You can download/install an addin from www.asap-utilities.com (ASAP
Utilities) and from the menu ASAP Utilities | Formula | Change reference
style, you can do all selected cells at once. Otherwise you'll need to do
it a cell at a time (notwithstanding those cells you can confirm at once w/
Ctrl + Enter). To do this, select the entire formula in the formula bar and
toggle through the reference styles with your F4 key.

HTH

 

[Paul B]

charsea, have a look here for some code by Peo Sjoblom to do it
http://tinyurl.com/gvdow
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003