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 on the cell with the left mouse button. 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 scrolls automatically if the mouse is dragged past the visible limits of the worksheet. To select additional blocks, hold down the CTRL key while clicking. 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. To deselect all selected cells, click the left mouse button anywhere within the worksheet or move the active cell with an arrow key or other movement key.