Chat with us, powered by LiveChat

Excel Themes

How to Create and Apply Custom Themes in Excel

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.

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

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

  6. 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.

FREE Quick Reference

Click to Download