Formula Bar

Shows or hides the Formula Bar, which is used for entering and editing formulas. The Formula Bar is the most important tool when working with spreadsheets.

To hide the Formula Bar, unmark the menu item.

To access this command...

From the menu bar:

Choose View - Formula Bar.

From the tabbed interface:

Choose View - Formula Bar

On the View menu of the View tab, choose Formula Bar.

From toolbars:

Formula Bar

If the Formula Bar is hidden, you can still edit cells by activating the edit mode with F2. After editing cells, accept the changes by pressing Enter, or discard entries by pressing Esc. Esc is also used to exit the edit mode.

View