|
To select |
Do this |
|
A single cell |
Click the cell, or press the arrow keys to moveto the cell. |
|
A range of cells |
Click the first cell in the range, and then dragto the last cell. |
|
A large range of cells |
Click the first cell in the range, and then hold down SHIFT and click the last cell in the range. You can scroll to make the last cell visible. |
|
An entire row |
Click the row heading. |
|
An entire column |
Click the column heading. |
|
Adjacent rows orcolumns |
Drag across the row or column headings. Or select the first row or column; then hold down SHIFT and select the last row or column. |
|
All cells on a datasheet |
Click the Select All button. |
|
More or fewer cellsthan the active selection |
Hold down SHIFT and click the last cell you want to include in the new selection. The rectangular range between the active cell andthe cell you click becomes the new selection. |
