OpenOffice.org OpenOffice - 3.0 Quick Start Guide download pdf (Page 136)

100

101

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:

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.

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

99.

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

136 Getting Started with OpenOffice.org 3

1 2 ... 131 132 133 134 135 136 137 138 139 140 141 ... 432 433

Comments to this Manuals

No comments

OpenOffice.org OpenOffice - 3.0 Quick Start Guide Page 136

Comments to this Manuals

Related products and manuals for Graphics software OpenOffice.org OpenOffice - 3.0