Office Settings & Configuration

Microsoft Excel: Change the Default Theme and Workbook Appearance

Ayan MasoodAyan Masood Nov 12, 2026 870 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open a blank workbook

Start Microsoft Excel and open a new blank workbook, or open the workbook whose appearance you want to reuse.

2
Open the Themes menu

Select the Page Layout tab, then choose Themes in the Themes group.

3
Choose or customize the appearance

Select a built-in theme, or use the Colors, Fonts, and Effects menus on the Page Layout tab to configure the workbook appearance.

4
Save the current theme

Select Page Layout > Themes > Save Current Theme, enter a name, and save the theme file.

5
Reuse the saved theme

For another workbook, select Page Layout > Themes and choose the saved custom theme from the available theme files.

Use a template for broader defaults: If you need more than theme settings, format a workbook as desired and save it as an Excel template. Store it in the XLSTART folder when you want Excel to use it for future workbooks, noting that defaults can vary depending on how a workbook is created.

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. 1. Open WPS Spreadsheet: Launch WPS Office and select Spreadsheet to open a blank workbook or an existing XLSX file.
  2. 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. 3. Save a reusable workbook: Choose Menu or File > Save As and save the formatted workbook as a template or reusable XLSX file.
  4. 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.
Create a consistent workbook appearance with coordinated colors, fonts, and formatting.Use a familiar spreadsheet interface to customize new workbooks quickly.Open and edit Microsoft Excel XLSX workbooks with strong format compatibility.Save reusable templates for recurring reports and spreadsheet projects.
microsoft office alternative - wps office

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.