Datasheet

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, press Ctrl+spacebar, 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 3-3 shows a simple example of a multisheet workbook. The workbook has four
sheets, named Totals, Marketing, Operations, and Manufacturing. The sheets are laid out
identically.
Figure 3-3: Each worksheet in this workbook is laid out identically.
Assume that you want to apply the same formatting to all sheets — for example, you want
to make the column headings bold with background shading. Selecting a multisheet range
is the best approach. When the ranges are selected, the formatting is applied to all sheets.
In general, selecting a multisheet range is a simple two-step process:
1. Select the range in one sheet.
2. Select the worksheets to include in the range.
Tip 3: Selecting Cells Efficiently
16
04_137666 ch01.qxp 5/22/07 7:31 PM Page 16