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. To deselect a single row from a multiple row selection, hold CTRL and click the row label. |
|
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. To deselect a column from a multiple column selection, hold CTRL and click the column label. |
|
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.