
Document themes coordinate the look of a worksheet with theme colors, theme fonts, and theme effects.
- Theme Colors: A set of 8 coordinated colors used to format text and objects in the worksheet.
- Theme Fonts: A set of coordinated heading and body font types.
- Theme Effects: A set of coordinated formatting properties for shapes and objects in the worksheet.
Apply a Workbook Theme
Themes help give your worksheet a consistent look and feel.
- Click the Page Layout tab.
- Click the Themes button.
Small thumbnails appear showing what each theme looks like.
- Select a theme.
The formatting associated with the selected document theme is applied to the workbook.
Customize a Document Theme
You are not bound to keep the colors, fonts, or effects that are assigned to a document theme. You may mix and match theme colors, theme fonts, and theme effects.
- Click the Page Layout tab on the Ribbon.
- Click the Theme Colors, Theme Fonts, or Theme Effects button and select the set of colors, fonts, or effects you want to use.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.
- Cell Styles in Excel
- Excel Conditional Formatting
- Excel Themes