Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Formula Bar

Shows or hides the Formula Bar, which is used for entering and editing formulae. 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...

Choose View - Formula Bar or View - 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.