Microsoft Office Tutorials and References
In Depth Information
Try some of the techniques described to select ranges of cells in the Dalton workbook.
To select a range of cells using keyboard shortcuts:
1. Click cell A1 to make it the active cell.
2. Press and hold the Shift key, click cell A5 , and then release the Shift key. Note that all of
the cells between A1 and A5 are selected.
Trouble? If the range A1:A5 is not selected, try again, but make sure you hold the Shift
key while you click cell A5.
3. Click cell A1 to make it the active cell again. Note that you don’t have to deselect one
range before clicking another cell.
4. Press and hold the Shift key, move the pointer to the bottom edge of cell A1 until the
mouse pointer changes to , and then double-click the bottom edge of cell A1 . The selec-
tion extends to cell A5, the last cell before the empty cell A6.
5. With the Shift key still pressed, move the pointer to the right edge of the selection until,
once again, the pointer changes to , double-click the right edge of the selection, and
then release the Shift key. The selection extends to the last nonblank column in the work-
sheet, selecting the range A1:G5.
6. Click the A column heading. All of the cells in column A are selected. Note that you didn’t
have to deselect the range A1:G5.
7. Click the 1 row heading. All of the cells in the first row are selected.
Moving a Selection of Cells
Now that you know various ways to select a range of cells, you can move the co-op data
down a few rows in the worksheet. To move a cell range, you first select it; then you posi-
tion the pointer over the selection border, and drag the selection to a new location. Try
this technique to move the order data from the cell range A1:G5 to the cell range A5:G9.
To move the order data:
1. Select the range A1:G5 , and then move the pointer over the bottom border of the selection
until the pointer changes to
2. Press and hold the left mouse button, changing the pointer to , and then drag the selection
down four rows. A ScreenTip appears indicating the new range reference of the selection.
See Figure 1-24.