Change the default theme

Important: For information about changing default themes in Excel/Word 2013 and later versions, see Change a theme and make it the default in Word or Excel. To change the overall Microsoft Office theme in Office 2013 and newer versions, see Change the Office theme.

A theme is a quick and easy way to give a professional and modern look to a Microsoft Office document. A document theme is a set of formatting choices that include a set of theme colors, a set of theme fonts (including heading and body text fonts), and a set of theme effects (including lines and fill effects).

The way in which document themes are used has evolved since their introduction and use Microsoft Office 2010, which are described in detail below.

If you want to change fonts or line spacing in yourOffice 2010 documents, see:

• Double-space the lines in a document
• Adjust the spaces between lines or paragraphs
• Change the font or font size in Excel
• Change the font size
• Change the default font or text color for email messages

Every document in Office 2010 that you create with Word, Excel or PowerPoint has a theme inside it — even blank, new documents. The default theme is Office Theme, with a white background and dark, subtle colors. When you apply a new theme, Office Theme is replaced by a new look, such as the dark background and bright colors of the Metro theme. If you want a different default theme from the Office Theme, you can save time by pre-configuring your document with a different default theme. All content (such as text, tables, and SmartArt graphics) is dynamically linked to the theme, so changing the theme automatically changes the look of your content, unless you customize it.

To change the default theme in Excel, you need to create a new, default workbook template or a new, default worksheet template. A workbook template can contain multiple worksheets, whereas a worksheet template contains only one worksheet. Workbook and worksheet templates can contain default text, such as page headers, column and row labels, formulas, themes, and other formatting information. The default workbook template is automatically used to create new workbooks, and the default worksheet template is used to automatically create new worksheets.

Create the default template from a new blank workbook

1. Click File, and then click New.
2. Under Available Templates, double-click Blank Workbook.
3. On the Page Layout tab, in the Themes group, click Themes.

• To apply a predefined document theme, under Built-In, click the document theme that you want to use.
• To apply a custom document theme that you created, under Custom, click the document theme that you want to use.

Note: Custom is available only if you create one or more custom document themes. For more information about creating custom document themes, see Apply or customize a document theme.

• To create a default workbook, enter book.xltx.
• To create a default worksheet, enter sheet.xltx.

Note: Any template in the default XLStart folder opens automatically when you start Microsoft Excel.

Create the default template from an existing workbook

1. Click File, and then click New.
2. Under Templates, click New from existing, and then in the New from Existing Workbook dialog box, browse to the computer, network, or Internet location that contains the workbook that you want to use.
3. Click the workbook, and then click Create New.
4. On the Page Layout tab, in the Themes group, click Themes.

• To apply a predefined document theme, under Built-In, click the document theme that you want to use.
• To apply a custom document theme, under Custom, click the document theme that you want to use.

Note: Custom is available only if you create one or more custom document themes. For more information about creating custom document themes, see Apply or customize a document theme.

• To create a default workbook, enter book.xltx.
• To create a default worksheet, enter sheet.xltx.

Note: you may be asked to contact your administrator for permission to save in this folder. If so, either contact your administrator or restart your system and sign in as administrator to complete this task.

Note: Any template in the default XLStart folder opens automatically when you start Excel.