Microsoft Office Tutorials and References
In Depth Information
Tip 10: Using Document Themes
Using Document Themes
Over the years, I’ve seen hundreds of Excel workbooks that were created by others. A significant
percentage of these workbooks have one thing in common: They are ugly!
In an effort to help users create more professional-looking documents, Microsoft designers (starting
with Office 2007) incorporated the concept of Office document themes. Using themes is an easy (and
almost foolproof) way to specify the colors and fonts and a variety of graphical effects in a document.
Best of all, changing the entire look of your document is a breeze. A few mouse clicks is all it takes to
apply a different theme and change the look of your workbook.
Importantly, the concept of themes is incorporated into other Office applications. Therefore, a
company can easily create a standard look for all its documents.
Elements within Excel that are controlled by document themes are
➤ Cells and ranges that use theme colors (as opposed to standard colors)
➤ Conditional formatting (but not always)
➤ Sparkline graphics
➤ Pivot tables
➤ PivotTable slicers and timelines
➤ Sheet tab colors
Figure 10-1 shows a worksheet that contains various Excel elements. These items all use the default
theme, which is known as Office Theme.
Figure 10-2 shows the same worksheet after applying a different document theme. The different
theme changes the fonts, colors (which may not be apparent in the figure), and graphical effects for
the SmartArt diagram.