OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 30)

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

STD field on the status bar and changing it to EXT, before clicking in

the opposite corner of the range of cells in step 3 above. If you use this

method, be sure to change EXT back to STD or you may find yourself

extending the 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.

The result of any of these methods looks like the right side of Figure 20.

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 26.

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 noncontiguous 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 another range

of cells to add to the first range.

4) Repeat as necessary.

Tip

You can also select a noncontiguous range of cells by first clicking

twice in the STD field on the status bar to change it to ADD, before

clicking on a cell that you want to add to the range of cells in step 3

above. This method works best when adding single cells to a range. If

you use this method, be sure to change ADD back to STD or you may

find yourself adding more selections unintentionally.

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 1).

To select a single row, click on the row identifier number.

30 OpenOffice.org 3.3 Calc Guide

1 2 ... 25 26 27 28 29 30 31 32 33 34 35 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 30

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3