Excel, what keyboard shortcut can I enter into edit formula field?

Question

Excel, what keyboard shortcut can I enter into edit formula field?
I know cell edit is F2. However, the field of the formula is much larger and editing there can be much more convenient. But how to get there without using the mouse ...?

[/ img]

Moran · Accepted Answer

F2. And before that, in the advanced options, uncheck the allow editing directly on cells. It applies to Excel 2010 ... and in 2007 probably the same.

Anonymous · Accepted Answer

You have a choice, you can edit in both fields without problem. F2 from the keyboard, double-click with the mouse.

Moran · Accepted Answer

This option does this to you for the entire worksheet - only then you are editing cells in the formula bar ONLY ...

There is no shortcut to do what you want ad hoc ... but here
http://www.cpearson.com/excel/FormulaBarShortcut.htm

there is a macro ;-)

)) that you can hook up to what you want ...

Moran · Accepted Answer

As I wrote there is no built-in shortcut key to take you to the Formula bar - you must use the mouse., Therefore the only way out is a macro ...

Anonymous · Accepted Answer

Unfortunately, such a shortcut does not exist and it is not weird.
If you have a long formula that does not fit in a cell (it is almost always the case), then it becomes visible in its entirety and there is definitely more space than in the formula bar, and you don't have to expand it like the aforementioned bar.

LINK

jkmkoszalin · Answer

Nice, a step forward, but not entirely satisfactory solution.
Since there are 2 fields to edit on the screen (cell and formula field), it would be nice to have a choice which I want to use. The more so because with the mouse in my hand I do not have to go through the advanced options ...

jkmkoszalin · Answer

I would like to be well understood. Sitting at Excel, I mainly work with the keyboard. I don't like mice. It is inconvenient to catch a rodent once in a while and click in the formula bar, or, after Moran's advice, right in the cell. I would like to know a shortcut that allows you to choose according to your needs. eg F2 and Alt + F2 (already taken for editing a comment). Perhaps such an abbreviation does not exist. But it would be weird. After all, I have access to every other field. If there was a reason why editing in a formula box was disabled, it would also be disabled for the mouse.

jkmkoszalin · Answer

I don't understand why it's not weird. Equally, bold fonts could only be accessed by clicking the icon, and there would be no Ctrl + B. The fact that there is a function that can be accessed with a mouse and that it is not possible to use a keyboard is strange. But this is not about banter. Thank you very much for your posts and interesting discussion. Until the next one

Excel, what keyboard shortcut can I enter into edit formula field?

Post #1

Post #2

Post #3

Post #4

Post #5

Post #6

Post #7

Post #8

Post #9

Didn't find an answer? Ask Artificial Intelligence

Topic summary