Always load a Custom Excel 2010 or Word 2010 Theme

If you have a custom theme (.thmx) saved or sent to you.

Copy the file into:

%AppData%\Microsoft\Templates\Document Themes\

To provide the theme to other users, copy the .thmx file to the same folder on each PC.

To Create a theme.

Theme colors contain four text and background colors, six accent colors, and two hyperlink colors.

The colors in the Theme Colors button Button image represent the current text and background colors, and the set of colors next to the name of the current theme after you click the Theme Colors button represent the accent and hyperlink colors for that theme. When you change any one of these colors to create your own set of theme colors, the colors in the Theme Colors button and next to the name of the theme change accordingly.

  1. On the Page Layout tab, in the Themes group, click Theme Colors.

The Themes group on the Page Layout tab.
The Themes group on the Page Layout tab in Excel 2010

  1. Click Create New Theme Colors.
  2. Under Theme colors, click the button of the theme color element that you want to change, and then select the colors that you want to use.

Customize the theme fonts

Theme fonts contain a heading font and a body text font.

When you click the Theme Fonts button Button image, you see the name of the heading and body text fonts used for each theme font below the Theme Fonts name. You can change both of these fonts to create your own set of theme fonts.

  1. On the Page Layout tab, in the Themes group, click Theme Fonts.

The Themes group on the Page Layout tab.
The Themes group on the Page Layout tab in Excel 2010

  1. Click Create New Theme Fonts.
  2. In the Heading font and Body font boxes, select the fonts that you want to use.

 Tip   The sample is updated with the fonts that you select.

  1. In the Name box, type an appropriate name for the new theme fonts, and then click Save.

Select a set of theme effects

Theme effects are sets of lines and fill effects.

When you click the Theme Effects button Button image, you see the lines and fill effects used for each set of theme effects in the graphic displayed with the Theme Effects name. Although you cannot create your own set of theme effects, you can choose the theme effect that you want to use in your own document theme.

  1. On the Page Layout tab, in the Themes group, click Theme Effects.

The Themes group on the Page Layout tab.
The Themes group on the Page Layout tab in Excel 2010

  1. Click the effect that you want to use.

Top of Page Top of Page

Save a document theme

You can save any changes that you make to the colors, fonts, or line and fill effects of a document theme as a custom document theme that you can apply to other documents.

  1. On the Page Layout tab, in the Themes group, click Themes.

The Themes group on the Page Layout tab.
The Themes group on the Page Layout tab in Excel 2010

  1. Click Save Current Theme.
  2. In the File Name box, type an appropriate name for the theme, and then click Save.

The custom document theme is saved in the Document Themes folder and is automatically added to the list of available custom themes.