Please remap F4 to the same action as in the formula bar

[santiago-afonso]

Hello again! Muscle memory makes me press F4 with the caret over a range when I want to cycle between absolute and relative references. That's standard Excel behavior for formula editing since forever, but the AFE uses F4 for enabling the selection of a range. It would be better if that feature had a different unused hotkey, say F6.

Also, the current select cell feature is limited. If you enter the select range mode and click on a cell, the reference changes without any animation or anything, the active cell changes, but the AFE remains in the edit mode of the original cell. So it is very confusing, sometimes it seems as if the formula in the AFE changed because I moved from the original cell. Perhaps a visual cue would make it less jarring.

[NWilson]

Hello! This is useful feedback. You're right, I chose F4 kind-of at random. Ideally the shortcut to enter cell-ref-edit mode would be F2, because that's what the formula bar uses, but unfortunately, that was taken by "rename" in the AFE editor.

I'm considering changing it so:

• F2 is "enter cell-ref-edit mode" to match Excel
• F4 is "change absolute/relative refs" to match Excel
• F6 is rename-named-formula

We'll consider what makes most sense.

[NWilson]

Internal ticket: CalcIntel #30674