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 Shortcut Keys

A list of the shortcut keys specific to creating formulae is contained in this section.

The general shortcut keys in Office also apply.

Shortcut Keys for Formula Functions

The following shortcut keys correspond to commands in the Edit and View menus.

F3

Next Error

Shift+F3

Previous Error

F4

Next Marker (Placeholder)

Shift+F4

Previous Marker (Placeholder)

F9

Update

Left or right arrow

Move left or right to the next category or function.

Enter key

Selects a category (within the category section) or inserts a function in the Commands window (within the function section).

Tab

Jump from the first category item to the first function of the category.

Shift+Tab

Jump from the last category item to the last function of the category.