Operation Manual

Selecting items in a spreadsheet
Selecting cells
Single cell
Left-click in the cell. You can verify your selection by looking in the Name Box on the Formula Bar
(Figure 90 on page 114).
Range of contiguous cells
A range of cells can be selected using the keyboard or the mouse.
To select a range of cells by dragging the mouse cursor:
1) Click in a cell.
2) Press and hold down the left mouse button.
3) Move the mouse around the screen.
4) Once the desired block of cells is highlighted, release the left mouse button.
To select a range of cells without dragging the mouse:
1) Click in the cell which is to be one corner of the range of cells.
2) Move the mouse to the opposite corner of the range of cells.
3) Hold down the Shift key and click.
Tip
You can also select a contiguous range of cells by first clicking in the Selection
mode field on the Status Bar (Figure 92 on page 115) and selecting Extending
selection before clicking in the opposite corner of the range of cells. Make sure to
change back to Standard selection or you may find yourself extending a cell
selection unintentionally.
To select a range of cells without using the mouse:
1) Select the cell that will be one of the corners in the range of cells.
2) While holding down the Shift key, use the cursor arrows to select the rest of the range.
Tip
You can also directly select a range of cells using the Name Box. Click into the
Name Box on the Formula Bar (Figure 90 on page 114). To select a range of cells,
enter the cell reference for the upper left-hand cell, followed by a colon (:), and
then the lower right-hand cell reference. For example, to select the range that
would go from A3 to C6, you would enter A3:C6.
Range of non-contiguous cells
1) Select the cell or range of cells using one of the methods above.
2) Move the mouse pointer to the start of the next range or single cell.
3) Hold down the Ctrl key and click or click-and-drag to select another range of cells to add to
the first range.
4) Repeat as necessary.
Chapter 5 Getting Started with Calc | 123