You might also be interested in
Replies (3)
Please login or register to join the discussion.
Insert $ for absolute cell ref
I have forgotten how to edit and insert $ sign into a cell reference by toggling 2 keys. e.g edit cell ref A2 to $A$2.
Can any remember this 2 key key stroke?
Thanks
Re: Insert $ for absolute cell ref
Press F2 to go to edit mode. Then pressing the F4 key will toggle between $A$1, A$1 and $A1.
Hope that helps,
Barbara.