Save Custom Colors for New Workbooks in Excel
Question details
Make preferred custom colors available in new Excel workbooks without recreating them each time.

- 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.
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.
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.
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.
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.
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.
Close and reopen Excel, then create a new blank workbook. On Page Layout, check that your custom theme colors are available.

Apply a Saved Theme to an Individual Workbook
Use a saved theme when you need the palette in an existing workbook or do not want to change the default template.
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.

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.




