
The result of any of these methods looks like the right side of Figure
104.
Tip
You can also directly select a range of cells using the Name
box. Click into the Name Box as described in “Using a cell
reference” on page 141. 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 Control key and click or click-and-drag to select a
range.
4) Repeat as necessary.
Selecting columns and rows
Entire columns and rows can be selected very quickly in OOo.
Single column or row
To select a single column, click on the column identifier letter (see
Figure 96).
To select a single row, click on the row identifier number.
Multiple columns or rows
To select multiple columns or rows that are contiguous:
1) Click on the first column or row in the group.
2) Hold down the Shift key.
3) Click the last column or row in the group.
To select multiple columns or rows that are not contiguous:
1) Click on the first column or row in the group.
2) Hold down the Control key.
3) Click on all of the subsequent columns or rows while holding
down the Control key.
Entire sheet
To select the entire sheet, click on the small box between the A column
header and the 1 row header (see Figure 107).
146 Getting Started with OpenOffice.org 3.x
Comentarios a estos manuales