Datasheet

Selecting a Range by Shift+Clicking
When you’re selecting a very large range, using the mouse may be the most efficient
method — but dragging is not required. Select the upper-left cell in the range. Then scroll
to the lower-right corner of the range, press Shift, and click the lower-right cell.
Selecting Noncontiguous Ranges
Most of the time, your range selections are probably simple rectangular ranges. In some
cases, you may need to make a multiple selection — a selection that includes nonadjacent
cells or ranges. For example, you may want to apply formatting to cells in different areas
of your worksheet. If you make a multiple selection, you can apply the formatting in one
step to all selected ranges. Figure 3-2 shows an example of a multiple selection.
Figure 3-2: A multiple selection that consists of noncontiguous ranges.
You can select a noncontiguous range by using either the mouse or the keyboard.
Press Ctrl as you click and drag the mouse to highlight individual cells or ranges.
From the keyboard, select a range as described previously (by using the Shift key). Then
press Shift+F8 to select another range without canceling the previous range selection.
Repeat this action as many times as needed.
Selecting Entire Rows
To select a single row, click a row number along the left of the worksheet. Or, select any
cell in the row and press Shift+spacebar.
To select multiple adjacent rows, click and drag in the row number area. Or, select any cell
in the first (or last) row, press Shift+spacebar, and use the arrow keys to extend the selec-
tion down (or up).
To select multiple nonadjacent rows, press Ctrl while you click the row numbers for the
rows you want to include.
Tip 3: Selecting Cells Efficiently
15
Part I
04_137666 ch01.qxp 5/22/07 7:31 PM Page 15