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?

Solution 1:

You should check the following article: Quick access to Excel formula bar via keyboard

If pressing [F2] positions the cursor in the cell instead of the Formula bar, do the following:

From the Tools menu, choose Options.
Click the Edit tab.
Uncheck the Edit Directly In Cell option in the Settings area.
Click OK.

If you’re using Excel 2007, do the following:

Click the Office button and then click Excel Options (at the bottom right).
Select Advanced in the left pane.
Uncheck the Allow Editing Directly In Cell option.
Click OK.

Solution 2:

Use CtrlU to access the formula bar in the Mac OS X version of Microsoft Excel.

Solution 3:

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.