Datasheet

14
1
1
2
Select Contiguous Cells
1 Click the first cell.
2 Drag to the last cell.
Alternatively, click the first cell, hold
down the Shift key, and then click
the last cell.
Select the Entire Worksheet
1 Click the Select All button ( ).
Alternatively, press Ctrl+A.
Select Cells
B
efore you can execute an Excel command, you
must select the cells to which you want the
command to apply. For example, if you want to
bold several cells, you start the process by selecting the
cells. The most common way to select cells is to click and
drag. Excel highlights the selected cells. The range of cells
you select does not have to be contiguous. You can hold
down the Ctrl key as you click and drag to select multiple
ranges of cells. If you select multiple ranges of cells, Excel
highlights each selected range. If you do not hold down
the Ctrl key, Excel deselects the first range of cells when
you begin to select a new range of cells.
You can select a single cell or the entire worksheet. To
select a single cell, click in the cell. To select every cell in
a worksheet, click the Select All button or press Ctrl+A.
To select an entire row or an entire column, simply click
the row or column identifier. For example, to select all the
cells in column C, click the C identifier for the column. To
select multiple columns, click the first column and then
continue holding down the mouse button as you drag to
the other columns you want to select. To select entire
rows, click the row identifiers on the left side of the rows.
You can quickly select a large range of cells by clicking in
the first cell you want to select, holding down the Shift
key, and then clicking in the last cell you want to select.
Select
Cells
03_591604-ch01.indd 1403_591604-ch01.indd 14 5/25/10 12:34 PM5/25/10 12:34 PM