Using F2 to edit cell leaves me unable to reference adjacent cells w/ the keyboard

[GordonZed]

This issue is unique.

• [X] I have used the search tool and did not find an issue describing my idea.

Your idea.

If I double click on a cell, and begin writing a formula, I can use my arrow keys to create cell references. This is great, except I need to use my mouse to begin with.

One would expect that F2 would be the solution, because I can edit the cell without reaching for the mouse, but then hitting the arrow keys only moves the text cursor, it doesn't let me select adjacent cells.

What I expect to happen is I can hit F2 again and then use the arrow keys to select adjacent cells, and then hit F2 yet again in order to move the text cursor.

Or at the very least, some version of a workflow that doesn't require moving my away from the keyboard, and then back again. I don't need it to be a clone of "the other spreadsheet app," but I do expect to be able to approach the same productivity.

If there is a shortcut of some description that will accomplish this, I could not find it in the documentation (but would love to know about it)

I don't know how helpful this visual is, but this is my attempt at a demonstration, lol. Mind the minor visual cruft.

[VladimirProkofiev52]

@GordonZed Hello! The behavior you describe is normal. For example, in the Excel editor the behavior is similar.

If you do not want to use the mouse, you can enter the address of the required cell in the form: “A12”.

[Rita-Bubnova]

I close this issue. Feel free to comment or reopen it if you got further questions.