fetraining
Aerospace
- Jul 29, 2008
- 17
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,
Tony Abbey
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