Microsoft Office Tutorials and References
In Depth Information
Selecting the current region
Selecting the current region
Often, you need to select a large rectangular selection of cells — the current region . To select the
entire block of cells, move the cell pointer anywhere within the range and press Ctrl+A.
If the cell pointer is within a table (created by using Insert Tables Table), pressing
Ctrl+A selects only the data. Press Ctrl+A a second time to select the table’s Header row
and Total row.
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 53-2
shows an example of a multiple selection.
Figure 53-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. When you’re finished, press Shift+F8 again to return to normal selecting mode.
Search JabSto ::

Custom Search