Office Settings & Configuration

Save Custom Colors for New Workbooks in Excel

Maira MehtabMaira Mehtab Nov 13, 2026 869 views

Question details

Make preferred custom colors available in new Excel workbooks without recreating them each time.

How to Save Custom Colors for New Excel Workbooks
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants a reusable color palette for future workbooks.
Observed behavior
Custom colors are not always retained as a reusable library across new workbooks.
Before you start

Identify the colors you want in your palette, including their RGB or hexadecimal values if available. Theme colors are managed in Excel, independently of Windows color settings.

Solution 1Recommended

Save a Custom Theme and Use It in a Default Workbook Template

Use this method to make your preferred theme colors available automatically in new Excel workbooks.

An Office theme stores a defined set of theme colors, fonts, and effects; it does not save every color from the recent or standard color lists.

The default-template steps below use the Windows XLSTART folder. On other systems, the template location may differ.

1
Create the color palette

Open a blank workbook in Excel. On the Page Layout tab, select Colors > Customize Colors. Choose each theme color you want to change, enter its color values, name the palette, and select Save.

2
Save the theme

Optionally choose Fonts and Effects on the Page Layout tab. Then select Themes > Save Current Theme, give the theme a name, and save the .thmx file.

3
Create the default template

With the theme applied to the blank workbook, select File > Save As and choose Excel Template (*.xltx). Name the file Book.xltx and save it in your Excel XLSTART folder. On Windows, you can enter %appdata%\Microsoft\Excel\XLSTART in File Explorer to find that folder.

4
Test a new workbook

Close and reopen Excel, then create a new blank workbook. On Page Layout, check that your custom theme colors are available.

Save a Custom Theme and Use It in a Default Workbook Template
Existing workbooks are unchanged: The template affects new workbooks created from the default template. Apply the saved theme separately to workbooks you have already created.
Free Microsoft Office alternative

Work With Spreadsheet Colors in WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. It supports common Excel formats, making it easier to move existing files between applications.

Format spreadsheet cells with your preferred colorsOpen and save common Microsoft Excel formats, including XLSXUse a familiar spreadsheet interfaceMove existing Office files into a lightweight alternative
microsoft office alternative - wps office

Frequently Asked Questions

Does saving an Excel theme save every custom color I have used?

No. A theme stores its defined theme color palette, along with fonts and effects. Colors in recent or standard color lists are not automatically saved as a reusable library.

How do I use my saved colors in an existing workbook?

Open the workbook and select Page Layout > Themes. Choose the saved theme, or use Browse for Themes to select its .thmx file, then save the workbook.

Why is my saved theme not appearing automatically in new workbooks?

Saving a .thmx theme alone does not make it the default. Apply it to a blank workbook and save that workbook as Book.xltx in Excel's XLSTART folder, then restart Excel and test a new blank workbook.

Do I need to change Windows color settings to customize Excel colors?

No. In Excel, use Page Layout > Colors > Customize Colors to create the theme palette. Windows color settings are separate.