Operation Manual

• Right-clicking on any of the arrows opens a context menu where you can select a sheet
(see Figure 101).
Note
When you insert a new sheet into a spreadsheet, Calc automatically uses the next
number in the numeric sequence as a name. Depending on which sheet is open when
you insert a new sheet, and the method you use to insert a new sheet, the new sheet
may not be in numerical order. It is recommended to rename sheets in a spreadsheet
to make them more recognizable.
Figure 100: Navigating sheet tabs
Figure 101: Right-click any arrow button
Keyboard navigation
To navigate a spreadsheet using the keyboard, pressing a key or a combination of keys. For a key
combination, press more than one key at the same time. Table 4 lists the keys and key
combinations you can use for spreadsheet navigation in Calc.
Table 4. Keyboard cell navigation
Keyboard
shortcut
Cell navigation
→ Moves cell focus right one cell.
← Moves cell focus left one cell.
↑ Moves cell focus up one cell..
↓ Moves cell focus down one cell
Ctrl+→ Moves cell focus to the first column on the right containing data in that row if cell
focus is on a blank cell.
Moves cell focus to the last column on the right in the same range of occupied
cells in that row if cell focus is on a cell containing data.
Moves cell focus to the last column on the right in the spreadsheet if there are no
more cells containing data.
126 | Getting Started with LibreOffice 5.1
Move to the first sheet
Move to the next sheet on the left
Move to the next sheet on the right
Move to the last sheet
Insert a new sheet after the last sheet
Sheet tabs