Microsoft Excel: Change the Default Theme and Workbook Appearance
Question details
The user needs to restore an earlier Excel theme or create a custom theme for new workbooks.
- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- The user wants to control the default colors, fonts, and visual effects used in new workbooks.
- Observed behavior
- New workbooks do not use the preferred theme or workbook appearance.
Open a blank workbook and decide which theme colors, fonts, and effects you want to reuse. If restoring an earlier appearance, identify the theme or workbook that contains the preferred formatting.
Apply or save a custom Excel workbook theme
Use this method to restore a built-in theme or create a reusable combination of colors, fonts, and effects.
Excel themes control coordinated workbook colors, fonts, and effects. Saving the current theme creates a theme file that can be applied to other workbooks later.
Start Microsoft Excel and open a new blank workbook, or open the workbook whose appearance you want to reuse.
Select the Page Layout tab, then choose Themes in the Themes group.
Select a built-in theme, or use the Colors, Fonts, and Effects menus on the Page Layout tab to configure the workbook appearance.
Select Page Layout > Themes > Save Current Theme, enter a name, and save the theme file.
For another workbook, select Page Layout > Themes and choose the saved custom theme from the available theme files.
Customize workbook themes and appearance in WPS Spreadsheet
WPS Spreadsheet lets you adjust a workbook's theme and visual style using familiar layout and formatting controls. Create a preferred appearance in a blank workbook, save it as a reusable template or theme-supported file, and apply it whenever you start a new project.
- 1. Open WPS Spreadsheet: Launch WPS Office and select Spreadsheet to open a blank workbook or an existing XLSX file.
- 2. Customize the workbook appearance: Use the Page Layout and formatting controls to adjust theme colors, fonts, effects, cell styles, and other visual elements.
- 3. Save a reusable workbook: Choose Menu or File > Save As and save the formatted workbook as a template or reusable XLSX file.
- 4. Apply the appearance to future workbooks: Open the saved template or copy the customized workbook whenever you need the same colors, fonts, and layout.

Frequently Asked Questions
Where do I find Excel's built-in themes?
Open the Page Layout tab and select Themes in the Themes group. Choose a built-in option to change the workbook's coordinated colors, fonts, and effects.
How can I save a custom Excel theme for later use?
After configuring the workbook, select Page Layout > Themes > Save Current Theme. Name and save the theme file, then select it from Page Layout > Themes in another workbook.
Can I change only the theme colors or fonts?
Yes. On the Page Layout tab, use the Colors or Fonts menu independently instead of replacing the entire theme. Effects can also be adjusted separately when supported by the selected theme.
Why does Excel still use a different appearance in some new workbooks?
Excel may use different defaults depending on how the workbook is created. For more consistent results, save a formatted workbook as an Excel template and use that template for future files.
Does changing a theme modify the worksheet data?
Changing a theme normally updates the workbook's coordinated colors, fonts, and effects without changing the underlying cell values. Direct formatting may remain unchanged or override theme settings.




