Operation Manual

• Using the keyboard – using key combinations Ctrl+Page Down moves one sheet to the
right and Ctrl+Page Up moves one sheet to the left.
• Using the mouse – clicking on one of the sheet tabs at the bottom of the spreadsheet
selects that sheet.
If your spreadsheet contains a lot of sheets, then some of the sheet tabs may be hidden behind the
horizontal scroll bar at the bottom of the screen. If this is the case:
• Using the four buttons to the left of the sheet tabs can move the tabs into view (Figure 98).
• Dragging the scroll bar edge to the right may reveal all the tabs.
• Right-clicking on any of the arrows opens a context menu where you can select a sheet
(see Figure 99).
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, 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 your
spreadsheet to make them more recognizable.
Figure 98: Navigating sheet tabs
Figure 99: Right-click any arrow button
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.
Chapter 5 Getting Started with Calc | 123