Microsoft Office Tutorials and References
In Depth Information
Selecting noncontiguous ranges
Press Ctrl+A to select all cells in the worksheet, which is the same as selecting all rows and all columns. If the active
cell is within a table (created by choosing Insert ➪ Tables ➪ Table), you may need to press Ctrl+A two or even three
times to select all cells in the worksheet. You can also click the area at the intersection of the row and column
borders to select all cells.
Selecting noncontiguous ranges
Most of the time, the ranges that you select are contiguous — a single rectangle of cells.
Excel also enables you to work with noncontiguous ranges, which consist of two or more
ranges (or single cells) that aren’t next to each other. Selecting noncontiguous ranges is
also known as a multiple selection. If you want to apply the same formatting to cells in
different areas of your worksheet, one approach is to make a multiple selection. When the
appropriate cells or ranges are selected, the formatting that you select is applied to them
all. Figure 14.13 shows a noncontiguous range selected in a worksheet. Three ranges are
selected: A2:C3, A5:C5, and A9:C10.
FIGURE 14.13
Excel enables you to select noncontiguous ranges.
14
You can select a noncontiguous range in several ways:
Select the fi rst range (or cell). Then press and hold Ctrl as you drag the mouse to
highlight additional cells or ranges.
From the keyboard, select a range as described previously (using F8 or the
Shift key). Then press Shift+F8 to select another range without canceling the
previous range selections.
Search JabSto ::




Custom Search