In addition to two-dimensional ranges on a single worksheet, ranges can extend across multiple worksheets to be three-dimensional ranges.

Suppose that you have a workbook set up to track budgets. A common approach is to use a separate worksheet for each department, making it easy to organize the data. You can click a sheet tab to view the information
for a particular department.

Say you have a workbook with four sheets, named Totals, Marketing, Operations, and Manufacturing. The sheets are laid out identically. The only difference is the values. The Totals sheet contains formulas that compute
the sum of the corresponding items in the three departmental worksheets.

Assume that you want to apply formatting to the sheets—for example, make the column headings bold with background shading. One (not so efficient) approach is simply to format the cells in each worksheet separately. A better technique is to select a multisheet range and format the cells in all the sheets simultaneously.

The following is a step-by-step example of multisheet formatting, using the example workbook described above.

1. Activate the Totals worksheet by clicking its tab.
2. Select the range holding the column headings, B3:F3 in the example.
3. Press Shift and click the sheet tab labeled Manufacturing. This step selects all worksheets between the active worksheet (Totals) and the sheet tab that you click—in essence, a threedimensional range of cells (see Figure 14-14). Notice that the workbook window’s title bar displays [Group] to remind you that you’ve selected a group of sheets and that you’re in Group edit mode.
4. Choose Home?Font?Bold and then choose Home?Font?Fill Color to apply a colored background.
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. Excel applies the formatting to the selected range across the selected sheets.

FIGURE 14-14
In Group mode, you can work with a three-dimensional range of cells that extends across multiple worksheets.
When a workbook is in Group mode, any changes that you make to cells in one worksheet also apply to 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.

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 appear with a white background, and Excel displays [Group] in the title bar.

• Hunter Laser Range Finder Scope 600 Yards Deer Bow NIB User Reviews Send this to a friend Hunter Laser Range Finder Scope 600 Yards Deer Bow NIB Manufacturer: GolferSam Customer...
• Home Renovation Budget Worksheet Owning a home is a dream for many people, and everyone has his own ideas about remodeling his own home....
• Acoustic Guitar Tablature Acoustic music tablature has now become the preferred method for reading and playing guitar music among many of the people...
• Creating a Plan for Guaranteed Retirement Income Regular readers of this blog may recall that I have been studying the work of Zvi Bodie, a professor of...