Office Settings & Configuration

How to Restore Excel Table Style Colors in Microsoft 365

Emma BrownEmma Brown Oct 10, 2026 873 views

Question details

The user needs to restore the standard table style colors that have unexpectedly changed or disappeared when formatting a spreadsheet.

How to Restore Excel Table Style Colors in Microsoft 365
Product
Microsoft 365 Excel
Device & OS
not provided
Scenario
Editing newly created files or older workbooks (including converted 2001-2008 files) where modern color options are missing from the table styles menu.
Observed behavior
The standard table style colors are replaced by older, legacy color examples, limiting the available formatting choices.
Before you start

Ensure your workbook is not operating in 'Compatibility Mode' and is saved in the modern .xlsx format, as older file formats restrict the use of newer theme colors.

Solution 1Recommended

Update the Workbook Color Theme

Switching the workbook's theme color set forces Excel to load modern table style colors instead of legacy palettes.

Excel table styles are directly linked to the active color theme of your workbook. If an older workbook was converted to XLSX or if the theme was accidentally changed, it may retain older color sets. Reverting the color palette to the standard Microsoft 365 default will restore the modern table styles.

1
Open the Page Layout Tab

Launch your workbook in Microsoft 365 Excel and navigate to the 'Page Layout' tab on the top ribbon.

2
Access Theme Colors

Locate the 'Themes' group on the left side of the ribbon and click on the 'Colors' dropdown menu.

3
Select the Modern Office Palette

Scroll through the list and select the 'Office 2013-2022' or standard 'Office' color set.

4
Verify Table Styles

Return to the 'Home' tab, click 'Format as Table', and verify that your standard table style colors are now restored.

Update the Workbook Color Theme
Tip: Applying the modern Office theme updates the colors globally across the current workbook, automatically adjusting any existing tables linked to theme colors.
Free Microsoft Office alternative

Format Spreadsheets Without Legacy Theme Conflicts in WPS Office

If you are frustrated by legacy theme limitations or formatting quirks in Microsoft 365, try WPS Office. It provides a lightweight, highly compatible environment with modern table styling tools that work seamlessly with older and newer spreadsheet files alike.

  1. 1. Install WPS Office: Download and install the free WPS Office suite on your device.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx or .xls file.
  3. 3. Apply Modern Formatting: Go to the Home tab and use 'Format as Table' to effortlessly apply beautiful, modern color themes.
Fully compatible with Microsoft Excel (.xlsx, .xls) formatsModern and intuitive table styles without legacy theme conflictsFree, lightweight, and fast alternative to Microsoft 365Familiar ribbon interface ensures a zero-learning-curve transition
microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel table colors suddenly change to older versions?

This usually happens because the workbook's theme was changed, or because the file originated from an older version of Excel (like Excel 2003 or earlier). Older files retain legacy color palettes even if they are opened in newer versions of Microsoft 365.

Does saving an old .xls file as .xlsx automatically fix table colors?

Not always. While converting to the modern .xlsx format enables new features, the workbook's internal color theme may still be set to the legacy palette. You must manually update the colors via Page Layout > Colors.

How can I make the modern Office theme the default for all new files?

New workbooks created in Microsoft 365 use the modern Office theme by default. If your new files are opening with old colors, you may have an outdated Book.xltx template file in your XLSTART folder that needs to be deleted or updated.