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 selected cell has 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  cursor not
the double arrow cursor used for selecting row dividing lines.
Hold CTRL and click a row label to deselect the row while keeping
the other rows selected.
|
| 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 cursor
not the double arrow cursor used for selecting column dividing
lines. Hold CTRL and click a column label to deselect the column
while keeping the other columns selected.
|
| 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.
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, click the left mouse button anywhere within the worksheet or move the active cell with an arrow key or other movement key.