42 Enter Simple Data into a Spreadsheet
Your mouse and arrow keys are the primary means of navigating keys for moving from cell to cell in sheets. Unlike Writer, which uses an insertion point, Calc uses its active cell, the highlighted cell, to indicate your current position in the sheet.
If you select multiple cells, the selection is considered to be a single set of active cells.
The active cell has a darkened border around it and accepts whatever data you enter. As you press an arrow key, Calc moves the cell pointer in the direction of the arrow to a new cell, making the new cell the active one. Once you begin typing inside a cell, the insertion point appears.
If you're working with a rather large sheet, you might find the
Navigator dialog box useful. Press
F5 to display the
Navigator dialog box, where you can select a range of cells that you might have previously named or enter a cell address, such as
C141 , to jump to that cell. You may also click any object in the
Navigator dialog box, such as a sheet name, or select a range name to jump to.
Use the Navigator dialog box to move around a spreadsheet efficiently.
Table 6.2 lists the most commonly used navigational keystrokes within Calc. Use your mouse to scroll with the scrollbars.
Press This Key… | To Move |
|---|---|
Arrow keys | The direction of the arrow, one cell at a time |
Ctrl+up arrow, | The topmost or bottommost cell that contains data or, if |
Ctrl+down arrow | at the end of the range already, the next cell that contains data or, if no cells above or below contain data, the top or bottom cell in the column |
Ctrl+left arrow, | The leftmost or riost cell that contains data or, if at |
Ctrl+right arrow | the end of the range already, the next cell that contains data, or, if no cells to the left or right contain data, the leftmost or riost cell in the row |
PageUp, PageDown | The previous or next screen of the worksheet |
Ctrl+Home | The upper-left corner of the worksheet (cell A1) |
Ctrl+PageUp, Ctrl+PageDown | The next or previous sheet within the current spreadsheet |
Ctrl+End | The bottom-right corner of the current range containing data |