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

Shortcut Keys (Office Calc Accessibility)

Refer also to the lists of shortcut keys for Office Calc and Office in general.

Some of the shortcut keys may be assigned to your desktop system. Keys that are assigned to the desktop system are not available to Office. Try to assign different keys either for Office, in Tools - Customise - Keyboard, or in your desktop system.

Cell Selection Mode

In a text box that has a button to minimise the dialogue box, press F2 to enter the cell selection mode. Select any number of cells, then press F2 again to show the dialogue box.

In the cell selection mode, you can use the common navigation keys to select cells.

Controlling the Outline

You can use the keyboard in Outline:

  • Press F6 or Shift+F6 until the vertical or horizontal outline window has the focus.
  • Tab - cycle through all visible buttons from top to bottom or from left to right.
  • Shift+Tab - cycle through all visible buttons in the opposite direction.
  • Ctrl+1 to Ctrl+8 - show all levels up to the specified number; hide all higher levels.
  • Use + or - to show or hide the focused outline group.
  • Press Enter to activate the focused button.
  • Use Up, Down, Left, or Right arrow to cycle through all buttons in the current level.

Selecting a Drawing Object or a Graphic

  1. Choose View - Toolbars - Drawing to open the Drawing toolbar.

  2. Press F6 until the Drawing toolbar is selected.

  3. If the selection tool is active, press Ctrl+Enter. This selects the first drawing object or graphic in the sheet.

  4. With Ctrl+F6 you move the focus to the document.

Now you can use Tab to select the next drawing object or graphic and Shift+Tab to select the previous one.