Microsoft Office Tutorials and References
In Depth Information
Selecting multisheet ranges
In Group mode, you can work with a three-dimensional range of cells that extend across
4. Choose Home
Fill Color to apply a
colored background. Excel applies the formatting to the selected range across the
Bold and then choose Home
5. Click one of the other sheet tabs. This step selects the sheet and also 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 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 the grouped worksheets.
When Excel is in Group mode, some commands are disabled and can’t be used. For example, in the preceding
example, you can’t convert all 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
contiguous worksheets, you can press Shift and click the sheet tab of the last worksheet that
you want to include in the selection. To select individual worksheets, press Ctrl and click
the sheet tab of each worksheet that you want to select. If all the worksheets in a
workbook aren’t laid out the same, you can skip the sheets that you don’t want to format. When
you make the selection, the sheet tabs of the selected sheets display in bold with
underlined text, and Excel displays [Group] in the title bar.