Log In

Interactive Tutorial

Excel Themes

How to Create and Apply Custom Themes in Excel

Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Try this course with a Free Trial

Interactive Tutorial

Practice live in your browser. No software required.

Try It Now

Excel 2021 Basic Course

4 Hour Course Certificate

View Course

Excel 2021 Basic Cheat Sheet

Free quick tips and shortcuts to use and share.

Download Cheat Sheet

Reference Guide

Step-by-step instructions with screenshots.

Reference Guide
Excel Themes

You can save any combination of theme colors, theme fonts, and theme effects as a new document theme.

Apply Theme Elements

Before saving the custom theme, you’ll have to apply the desired theme colors, theme fonts, and theme effects to the current workbook.

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

    3. In the menu, select from the built-in font sets or a custom one you’ve created.

  3. Select a font theme.
    Apply Theme Elements
  4. Click the Colors button.

    Once again, you can choose a built-in color scheme or a custom scheme.

  5. Select a color palette.
    Apply Theme Elements

Create a Custom Theme

  1. Click the Page Layout tab.
  2. Click Themes.
  3. Click Save Current Theme.
    Create a Custom Theme
  4. Enter a name for your theme.
  5. Click Save.
    6. Create a Custom Theme

The new theme is now available in the Custom section of the Themes menu. Custom themes you’ve saved will be available for use in all your Office applications. You can even share the theme file with others, so they can also use your new theme.

To remove a custom theme or theme element, right-click the theme in the menu and select Delete. Finally, click Yes to confirm the deletion.