Office Settings & Configuration

Restore the Original Theme Color Palette in Excel

Rana GarciaRana Garcia Nov 12, 2026 869 views

Question details

Restore the original workbook theme so Excel themed cell styles and colors return to their expected appearance.

Restore the Original Theme Color Palette in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to recover the familiar colors used by themed cells, tables, charts, and style presets in a workbook.
Observed behavior
Themed cell styles are displaying different colors because the workbook theme may have been changed.
Before you start

Open the workbook whose colors are incorrect and compare it with an earlier copy or another workbook that has the desired appearance. If the file used a custom theme, locate the original workbook before changing theme settings.

Solution 1Recommended

Select the Previously Used Excel Theme

Use this method when the workbook colors changed after a built-in theme was selected or imported.

Excel themes control the color, font, and effect sets used by themed cell styles. Selecting the prior theme updates theme-based formatting throughout the workbook.

1
Open the Page Layout tab

In Excel, open the affected workbook and select the Page Layout tab on the ribbon.

2
Open the Themes gallery

In the Themes group, select Themes to display the available workbook themes.

3
Choose the original theme

Select the theme previously used by the workbook. If you need the familiar modern Office color set, choose Office 2013–2022 Theme when it is available.

4
Check themed formatting

Review cells that use Cell Styles, tables, charts, or SmartArt to confirm that their theme colors have returned.

Select the Previously Used Excel Theme
Theme colors restored: After you select the correct theme, save the workbook to keep the restored color palette.
Restore workbook theme colors with WPS Spreadsheet

Apply the Correct Workbook Theme in WPS Spreadsheet

WPS Spreadsheet lets you apply a workbook theme to restore coordinated colors for themed cells, tables, charts, and other formatted content. Open the affected file, choose the intended theme from the Page Layout tools, and save the workbook after checking the results.

  1. 1. Open the Excel workbook: Launch WPS Spreadsheet and open the affected .xlsx or .xls workbook.
  2. 2. Go to Page Layout: Select the Page Layout tab on the WPS Spreadsheet ribbon.
  3. 3. Choose a workbook theme: Select Themes and choose the theme that matches the workbook's original color palette.
  4. 4. Review themed items: Check Cell Styles, tables, and charts to verify that their colors update as expected.
  5. 5. Save the workbook: Select Menu > Save or press Ctrl+S to keep the corrected theme in the workbook.
Restore consistent theme colors for spreadsheet cell styles and visual elements.Use Page Layout theme controls in a familiar spreadsheet interface.Open and save Microsoft Excel .xlsx and .xls files with format compatibility.Work with a free, lightweight office suite for everyday spreadsheet editing.
microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel cell style colors change all at once?

Cell styles that use theme colors update when the workbook theme changes. Go to Page Layout > Themes and select the theme that was used previously.

Which Excel theme restores the familiar Office color palette?

In many Excel versions, selecting Page Layout > Themes > Office 2013–2022 Theme restores the familiar modern Office cell-style colors.

Can I recover colors if the workbook used a custom theme?

Yes. Open the original workbook, select Page Layout > Themes > Save Current Theme, then open the affected workbook and use Page Layout > Themes > Browse for Themes to apply it.

Will changing the theme alter every manually formatted cell?

No. Theme changes primarily affect content using theme colors, theme fonts, and theme effects. Cells formatted with fixed custom colors generally remain unchanged.