Datasheet
29
Chapter 1: Making Excel More Efficient
77
88
66
8 Click the tab of a
worksheet in the group.
● The data and formatting
you added to the original
worksheet also appear
inthe other worksheets
in the group.
6 Add the text and other
data you want to display
on the grouped
worksheets.
7 Apply the formatting that
you want to use on the
grouped worksheets.
More Options!
If you have a workbook with a large number of
worksheets and you want to include most or all
of those sheets in your group, do not click each
worksheet tab individually. To group every sheet,
right-click any tab and then click Select All Sheets;
alternatively, click the first tab you want to include
in the group, hold down Shift, and then click the
last tab you want to include.
Remove It!
To exclude a worksheet from the
group, hold down Ctrl and click
the worksheet’s tab. To collapse
the entire group, either click any
tab that is not part of the group, or
right-click a grouped tab and then
click Ungroup Sheets.
03_577769-ch01.indd 2903_577769-ch01.indd 29 3/27/10 9:00 AM3/27/10 9:00 AM