Chapter 5: Formatting Worksheets
55
A theme applies to the entire workbook. You can’t use different themes on different worksheets within a workbook.
FIGURE 5.25
Built-in Excel theme choicesWhen you specify a particular theme, the gallery choices for various elements reflect the new
theme. For example, the chart styles that you can choose from vary, depending on which
theme is active.Because themes use different fonts (which can vary in size), changing to a different theme may affect the layout of
your worksheet. For example, after you apply a new theme, a worksheet that printed on a single page may spill over to
a second page. Therefore, you may need to make some adjustments after you apply a new theme.
Customizing a theme
Notice that the Themes group on the Page Layout tab contains three other controls: Colors,
Fonts, and Effects. You can use these controls to change just one of the three components
of a theme. For example, you might like the colors and effects in the Office theme but
would prefer different fonts. To change the font set, apply the Office theme and then spec-
ify your preferred font set by choosing Page Layout ➪ Themes ➪ Fonts.