short cut to fixed cell definition input type $A$1
short cut to fixed cell definition input type $A$1
(OP)
I have been shown in the past how to use a built in hot key or function key to make any cell reference in an equation a fixed reference, on the fly. However I have forgotten how and can't find any reference in the help documentation.
So instead of clicking on cell A1 when building an equation, getting A1 in the input line, then manually editing to $A$1, there is a hot key that will cycle through $A$1, A$1, $A1.
many thanks,
So instead of clicking on cell A1 when building an equation, getting A1 in the input line, then manually editing to $A$1, there is a hot key that will cycle through $A$1, A$1, $A1.
many thanks,
Tony Abbey www.fetraining.com





RE: short cut to fixed cell definition input type $A$1