1.1

Navigating within worksheets
Figure 10. Creating a new sheet
If you need more sheets, an easy way to create them
is to click into the little empty space at the right of
the last sheet tab (as in Figure 10). Or you can select
Insert > Sheet from the Menu bar, or right-click on
one of the sheet tabs and select Insert Sheet.
Figure 11. Moving from sheet to sheet
If you have 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, then
the four buttons at the left of the sheet tabs can
move the tabs into view. Figure 11 shows how to do
this.
Notice that the sheets here are not numbered in
order. Sheet numbering is arbitrary – you can name
a sheet as you wish.
Finally, you can move between sheets by using
Control+PageUp (moves left one sheet) or
Control+PageDown (moves right one sheet).
Navigation shortcuts
Table 1 lists the key combinations for navigating within Calc.
Table 1. Moving from cell to cell using the keyboard
Key
Combination
Movement
→
Right one cell
←
Left one cell
↑
Up one cell
↓
Down one cell
Control+→
To last column containing data in that row or to Column IV
Control+←
To first column containing data in that row or to Column A
Control+↑
To first row containing data in that column or to Row 1
Control+↓
To last row containing data in that column or to Row 32000
Control+Home
To Cell A1
Control+End
To lower right hand corner of the square area containing data
Alt+PageDown
One screen to the right (if possible)
Alt+PageUp
One screen to the left (if possible)
Getting Started with Calc 10
Click here to create
a new sheet
Move to the last
sheet
Move left one sheet
Move to the first sheet
Sheet tabs
Move right one sheet