Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from Nov 1 '10 at 12:36

This question came from our site for professional and enthusiast programmers.

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.

share|improve this answer

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

share|improve this answer
Ctrl-U also switches focus from search box to cell in Mac OS X version of Microsoft Excel. – Adam F May 25 at 18:17

Tools - Options - Edit - Edit directly in cell (*un*tick)

Now, F2 will do it.

share|improve this answer

I just use F2 and edit cell content in place. I'm not sure if that gives any benefit / drawbacks over using the formula bar directly, though...

share|improve this answer

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.

share|improve this answer

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.

share|improve this answer

You must log in to answer this question.