Microsoft Office Tutorials and References
In Depth Information
Figure 7–10. Out of hiding: Where to unhide a sheet
Click OK, and the sheet reappears.
You can al so group several worksheets, meaning that you can select them simultaneously. Why bother?
Because by doing so, any data entry or formatting change you make in a range in one grouped sheet
will be reproduced in precisely the same range in all the other grouped sheets, affording you a highly
efficient way to achieve the same data arrangement and look across sheets. Thus if you enter a series
of header rows in one grouped sheet—say, Name, Address, and Age—all those entries will appear in
the same addresses on the other sheets.
To group sheets, click on the first one you want to group. You’re then handed two group options: If
you want to group non-adjacent sheets in a workbook, press Ctrl, leave that key down, and then click
on the other sheets you want to group. Then release Ctrl. If you want to group adjacent sheets, click on
the first tab you wish to group, then press Shift, leave that key down, and click on the last in the series of
sheet tabs. To select all the sheets in the workbook, you can right-click any sheet tab and click b.
To demonstrate, open a new blank workbook and click the tab of Sheet1. Press Shift and at the
same time click the Sheet3 tab (yes; you could have also clicked Select All Sheets, as per the instructions
in the last paragraph). All three tabs should appear white (or at least whiter than usual, in the event
you’ve colored any tabs), with the tab text “Sheet 1” appearing in boldface, indicating it is the active
sheet. Then in cell A1 type Name, then Address and Age in cells B1 and C1, respectively. Then click
Sheets 2 and 3—and you’ll see the same data in the same cells. To deselect, or ungroup, the sheets,
right-click any tab and click Ungroup Sheets (another dorky verb), or click on any sheet that is not
cur r e n tl y g r oupe d.
Far-Flung Formulas: Working with Multi-Sheet Cell
Now what about those multi-sheet cell references? As stated earlier, you can write formulas in which
cells in different worksheets contribute to that formula result. For example, if you allocate a separate
worksheet to each of three employees and enter their salary in the same cell on each sheet—say cell