Forum Discussion
Make External Cell References Relative by Default
My suggestion is Click Another Workbook Reference -> Rename -> Apply 'F4'
It will remove '$' symbol. $A$10 will become A10.
My suggestion is Click Another Workbook Reference -> Rename -> Apply 'F4'
It will remove '$' symbol. $A$10 will become A10.
Logaraj Sekar, I think that is probably the best I can suggest to this user. It saves some clicking, at any rate.
SergeiBaklan, me either, but I promised that I would look into it some. This user is also an executive in our organization, so it required a little extra effort besides saying "it can't be done".
Stephan, the question about default settings for references is quite old, more than 10 years for sure. My guess F4 shortcut was introduced very long ago as partial answer on this question.
However, if you find something (e.g. changing of registry key, or, fortunately, more simple option) please share then.
As for F4 please take into account it works in circular mode, with each click it goes through absolute-two mixed-relative reference changing cycle.
