If you are talking about making relative references like = A1 absolute
references like = $A$1 then take a look at:
http://www.ozgrid.com/VBA/formula-ref-change.htm
"MDV" wrote:
Is there a way to insert $ signs in front of certain cell characters on a
global basis?
I am facing having to click on each cell reference in a large spreadsheet
and hit F4 each time to insert the $ signs to anchor the cell reference. If
anyone knows of a way to change the entire spreadsheet to insert the $ signs
into each cell reference, I would very much appreciate hearing from you.
Thank you,
Mary