Microsoft Office Tutorials and References
In Depth Information
Selecting entire rows
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 4-2 shows an example of a multiple selection.
Figure 4-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, and press Shift+spacebar to select one row. Then press Shift and use the arrow
keys to extend the row selection down (or up).
To select multiple nonadjacent rows, press Ctrl while you click the row numbers for the rows you
want to include.
Selecting entire columns
To select a single column, click a column letter along the top of the worksheet. Or, select any cell
in the column and press Ctrl+spacebar.
To select multiple adjacent columns, click and drag in the column letter section. Or, select any cell
in the first (or last) column, and press Ctrl+spacebar to select one column. Then press Shift and
use the arrow keys to extend the selection to the right (or left).
 
Search JabSto ::




Custom Search