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 ![]() |
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 ![]() |
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.