Microsoft Office Tutorials and References
In Depth Information
Selecting entire rows
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 the 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 the column. Then press Shift and use the
arrow keys to extend the selection to the right (or left).
To select multiple nonadjacent columns, press Ctrl while you click the column letters for the columns
you want to include.
Selecting multisheet ranges
In addition to two-dimensional ranges on a single worksheet, ranges can extend across multiple
worksheets to be three-dimensional ranges.
Figure 53-3 shows a simple example of a multisheet workbook. The workbook has four sheets,
named Totals, Operations, Marketing, and Manufacturing. The sheets are laid out identically.
Figure 53-3: Each worksheet in this workbook is laid out identically.
Search JabSto ::




Custom Search