Microsoft Office Tutorials and References
In Depth Information
Apply Text or Formatting to Multiple Worksheets
Apply Text or Formatting
to Multiple Worksheets
You can speed up the creation of spreadsheet
models by applying text and formatting to
multiple worksheets at once.
In most workbooks, the worksheets are related
in some way, but they generally have
significantly different structures. However, in
certain cases each worksheet uses an identical
structure. For example, each worksheet might
have the same overall title. Similarly, in a
budget workbook each worksheet might have
not only the same title, but also the same
headings (Income, Expenses, and so on).
If you just have a small number of worksheets,
you can also complete one worksheet’s
structure, copy the range, and then paste it into
the other sheets. For a large number of sheets,
however, Excel offers a much faster method.
You can collect all the worksheets into a group
where Excel treats the collection of sheets as a
single worksheet. This means that any data you
enter into one sheet is automatically entered on
the same spot in every other sheet in the group;
similarly, any formatting applied to one sheet is
also applied to the entire group.
1 Click the tab of the first
worksheet you want to
include in the group.
2 Press and hold Ctrl.
1
3 Click the tab of the next
worksheet you want to
include in the group.
Excel displays [Group] in
the title bar to remind
you that your worksheets
are currently grouped.
Note: If you select a tab
accidentally, click the tab again to
remove the worksheet from the
group.
4 Repeat step 3 for each
worksheet you want to
include in the group.
5 Release the Ctrl key.
3
4
 
Search JabSto ::




Custom Search