Chat with us, powered by LiveChat

How to Change a Theme in Excel

How to Apply a Theme in Excel

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.

  1. Click the Page Layout tab.
  2. Click the Themes button.

    Small thumbnails appear showing what each theme looks like.

  3. Select a theme.
    Apply 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.

  1. Click the Page Layout tab on the Ribbon.
  2. Click the Theme Colors, Theme Fonts, or Theme Effects button and select the set of colors, fonts, or effects you want to use.
    Apply a Theme