Operation Manual

Note
The sheet tab arrows that appear in Figure 98 are only active if there are sheet
tabs that cannot be seen.
Note
When you insert a new sheet into your 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, your new sheet may not be in numerical order.
It is recommended to rename sheets in your spreadsheet to make them more
recognizable.
Figure 98. Navigating sheet tabs
Keyboard navigation
Pressing a key or a combination of keys allows you to navigate a spreadsheet using the keyboard.
A key combination is where you press more than one key together, for example Ctrl+Home key
combination to move to cell A1. 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 containing data 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.
Ctrl+← Moves cell focus to the last column on the left containing data in that row if
cell focus is on a blank cell.
Moves cell focus to the first column on the left containing data in the
spreadsheet if cell focus is on a cell containing data.
Moves cell focus to the first column in that row if there are no more cells
containing data.
Chapter 5 Getting Started with Calc | 121