Part I: Getting Started with Excel
FIGURE 4.4
In Group mode, you can work with a three-dimensional range of cells that extend across mul-
tiple worksheets.
- Choose Home ➪ Font ➪ Bold and then choose Home ➪ Font ➪ Fill Color to apply a
colored background. Excel applies the formatting to the selected range across the
selected sheets.
- Click one of the other sheet tabs. This step selects the sheet and cancels Group
mode; Group is no longer displayed in the title bar.
When a workbook is in Group mode, any changes that you make to cells in one worksheet
also apply to the corresponding cells in all of the other grouped worksheets. You can use
this to your advantage when you want to set up a group of identical worksheets because
any labels, data, formatting, or formulas you enter are automatically added to the same
cells in all of the grouped worksheets.
When Excel is in Group mode, some commands are disabled and can’t be used. For example, in the preceding exam-
ple, you can’t convert all of these ranges to tables by choosing Insert ➪ Tables ➪ Table.
In general, selecting a multisheet range is a simple two-step process: select the range in
one sheet and then select the worksheets to include in the range. To select a group of con-
tiguous worksheets, select the first worksheet in the group and then press Shift and click
the sheet tab of the last worksheet that you want to include in the selection. To select
individual worksheets, select one of the worksheets in the group and then press Ctrl and
