Selecting Cells with the Mouse

 

The mouse may be used to select cells. Selected cells are indicated by reverse video (white background becomes black, etc.).

 

To Select

Process

Single cells

Click the left mouse button on the cell. The cell will have a thick outline around it.

A rectangular block of cells

Move the active cell to one corner of the block. Click and hold the left mouse button, and drag it to the opposite corner of the block. Then release the mouse button.

An entire row

Click the mouse on the row label.

Several adjacent rows

Click and hold the mouse on the first row label and drag it to the last row. Make sure the cursor is a normal arrow cursor not the double arrow cursor used for selecting column dividing lines.

An entire column

Click the mouse on the column label.

Several adjacent columns

Click and hold the mouse on the first column label and drag it to the last column. Make sure the cursor is a normal arrow cursor not the double arrow cursor used for selecting column dividing lines.

The entire worksheet

Click on the small box above the row labels and to the left of the column label bar.

 

The worksheet will scroll automatically if the mouse is dragged past the visible limits of the worksheet.

 

Select Additional Blocks

To select additional blocks, hold down the CTRL key while clicking.

 

Resize the Last Selected Block

To resize the last selected block, hold down the SHIFT key while clicking and holding the left mouse button. Then, drag the edge of the last selected block to the new position. The last block cannot be resized if the active cell has been moved.

 

Deselect All Selected Cells

To deselect all selected cells, left-click anywhere within the worksheet or move the active cell with an arrow key or other movement key.

 

 

See Also

Selecting Cells

Selecting Cells with the Keyboard