Microsoft Office Tutorials and References
In Depth Information
Apply Text or Formatting to Multiple Worksheets
Chapter 1: Making Excel More Efficient
6 Add the text and other
data you want to display
on the grouped
7 Apply the formatting that
you want to use on the
8 Click the tab of a
worksheet in the group.
The data and formatting
you added to the original
worksheet also appear
in the other worksheets
in the group.
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.
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.