Absolute Reference Shortcut
Really simple. Pretty much in all my data analysis involves absolute references and relative references. For a formula I enter, I have to go through and manually type in the $ symbols to lock those references, which can be cumbersome when I have 15 or so references to take care of. What I suggest is a shortcut key e.g. ctrl + click/alt + click where by clicking the cell in the formula using this combination will convert it to an absolute reference.
Anonymous
shared this idea
Great news, we have this in Excel already. as you are authoring a formula, when you select a cell/range, you can press F4 to toggle the “absolute-ness” of the reference.
cheers,
dan [MS]
4 comments
-
Geoffroy Menard
commented
That is not what he meant. It's not about being able to toggle the references after they've been entered, we want a keyboard modifier that will right away set the right one when we click the cell.
-
Anonymous
commented
The F4 key was so useful, I used to use it all the time. Somehow MS has removed this feature with the latest version. I hope it is reinstated.
-
Ben Sacheri
commented
This works for cell references but not table references. If you are searching for a way to do this with table and column references, please vote here:
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10517694-use-f4-key-to-lock-reference-in-a-table -
Gavin Mears commented
Try F4 to cycle through the $ options