Change the default theme

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.

   

4. To apply a theme to the workbook that every new workbook will use, do one of the following:

   • 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 apply a document theme that is not listed, click Browse for Themes to find it on your computer or on a network location.

   • To see other document themes from Microsoft Office Online, pick one of the themes listed in the From Office.com category of predefined themes.

5. Click File, then click Save As.

6. Browse to your XLStart folder. Location is C:\Program Files\Microsoft Office\Office14\XLSTART

   and then in the File name box, do one of the following:

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

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

7. In the Save as type list, click Excel Template (*.xltx), and then click Save. Note that you may be asked to contact your administrator for permission to save in this folder. If so, contact your administrator. If you own the administrator account, restart your system and sign in as administrator to complete this task.

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.

   

5. To apply a theme to the workbook that every new workbook will use, do one of the following:

   • 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 apply a document theme that is not listed, click Browse for Themes to find it on your computer or on a network location.

   • To search for other document themes on Microsoft Office Online, pick one of the themes listed in the From Office.com category of predefined themes.

6. Click File, then click Save As.

7. Browse to your XLStart folder. Location is C:\Program Files\Microsoft Office\Office14\XLSTART

   and then in the File name box, do one of the following:

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

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

8. In the Save as type list, click Excel Template (*.xltx), and then click Save.

   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.

9. In the Save as type list, click Excel Template (*.xltx), and then click Save.

• On the Design tab, in the Themes group, right-click the theme that you want, and then click Set as Default Theme on the shortcut menu. To view more theme thumbnails, click More .

  

To change the overall look of your Word 2010 document, you change both the theme and the style set. You can then set this as the default for all new documents. In Word 2010, the look of a style set is so closely tied to the fonts and colors used in the theme that the theme fonts and theme colors can be changed both on the Home tab in Change Styles (Styles group), and on the Page Layout tab in the Themes group where you can also change the entire theme.

1. Click File, and then click New > Blank document.

2. On the Home tab, in the Styles group, click Change Styles, point to Style Set, and then click the Quick Style set that you want to use.

   

   The gallery of Quick Styles changes to reflect the new Quick Style set.

3. Click Change Styles again, point to Colors, and then choose the colors that you want to use.

4. Click Change Styles again, point to Fonts, and then choose the fonts that you want to use.

5. To adjust the paragraph or line spacing before setting the default theme, see Adjust the spaces between lines or paragraphs.

6. Click Change Styles again, and then click Set as Default.

   On the Page Layout tab, the buttons in the Themes group update to reflect your changes.