Microsoft Office Tutorials and References
In Depth Information
Working with Themes
Changing the theme made a signiﬁ cant difference in the worksheet’s appearance.
The most obvious changes are the ﬁ ll colors and the fonts. Only elements directly tied
to a theme change when you select a different theme. The cells you formatted with the
Accent1 cell style changed because the Accent1 color is blue in the Ofﬁ ce theme and
orange in the Apex theme. The Heading 1 style you applied to the titles in cells A1 and
A2 uses the Cambria typeface in the Ofﬁ ce theme and the Lucida Sans typeface in the
Apex theme. The Apex theme also uses a different font for body text, which is why the
rest of the text changed size and appearance.
The logo colors in cell A1 did not change because you used two standard colors, blue
and red, which are not part of a theme. Changing the theme does not affect these colors.
Tom prefers the default Ofﬁ ce theme, so you’ll reapply that theme.
To select the Office theme:
1. In the Themes group on the Page Layout tab, click the Themes button, and then
click the Office theme from the gallery of themes.
Teamwork: Sharing Styles and Themes
Using a common style and design theme for all the files you create in Microsoft Office is a
simple way to give your files a consistent look and feel and project a professional image.
This consistency is especially important when a team of workers is collaborating on a set of
documents. When all team members work from a common set of style and design themes,
readers will not be distracted by inconsistent or clashing styles.
To quickly copy the styles from one workbook to another, open the workbook with the
styles you want to copy, and then open the workbook in which you want to copy those
styles. In the Styles group on the Home tab, click the Cell Styles button, and then click
Merge Styles. The Merge Styles dialog box opens, listing the currently open workbooks.
Select the workbook with the styles you want to copy, and then click the OK button to copy
those styles into the current workbook. If you modify any styles, you must copy the styles to
the other workbook; Excel does not update styles between workbooks.
Because other Office files, including those created with Word or PowerPoint, use the
same file format for themes, you can create one theme to use with all the Office files you
create. To save a theme, in the Themes group on the Page Layout tab, click the Themes
button, and then click Save Current Theme. The Save Current Theme dialog box opens.
Select a save location (in a default Theme folder on your computer or another folder), type
a descriptive name in the File name box, and then click the Save button. If you saved the
theme file in a default Theme folder, the theme appears in the Themes gallery, and any
changes made to the theme are reflected in any Office file that uses that theme.
By creating a library of styles and themes, you can create a report containing pages
generated from different Office programs and those pages will still share a consistent set
of design elements. Employees with expertise in page design can design a theme for the
rest of the team to use. If those styles and themes are changed or modified, the new design
style can be quickly applied to new and existing documents without having to reformat
each document. Through careful planning, a well-designed theme can save you and your
colleagues a lot of effort later on.