Home » Questions » Computers [ Ask a new question ]

How can I change the focus in Excel to the formula bar via the keyboard?

How can I change the focus in Excel to the formula bar via the keyboard?

I like to avoid using my mouse as much as possible, but on occasions when I need to type directly into the formula bar I am currently forced to 'rattle the rodent'. Does anyone know a way to move focus from the worksheet cells into the formula bar with a keystroke combination?

Asked by: Guest | Views: 80
Total answers/comments: 3
Guest [Entry]

"I just learned that there's a way to do this without having to change the option that all of the other answers mention.

Press F2, then Ctrl+A.

This pleases me greatly.

Verified working in the following Microsoft Office for Windows versions:
Excel 2003, 2007, 2010, 2013 and 2016."
Guest [Entry]

"If using 2010 (I understand this is a old thread, for people searching these days), go to file, options, advanced, untick ""allow editing directly in cell"".

Then F2 should take you to formula bar."
Guest [Entry]

"You can edit the contents of a cell by pressing the F2 key.

A full listing of Excel keyboard shortcuts can be found in this XLS."