Chapter 4: Working with Cells and Ranges
73
FIGURE 4.3The worksheets in this workbook are laid out identically.
Assume that you want to apply formatting to the sheets — for example, make the column headings
bold with background shading. One (albeit not-so-efficient) approach is 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 workbook shown in Figure 4.3.- Activate the Totals worksheet by clicking its tab.
- Select the range B3:F3.
- Press Shift and click the Manufacturing sheet tab. This step selects all worksheets
between the active worksheet (Totals) and the sheet tab that you click — in essence, a
three-dimensional range of cells (see Figure 4.4). 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 mode.
FIGURE 4.4
In Group mode, you can work with a three-dimensional range of cells that extend
across multiple worksheets.