Save Custom Excel Fill Colors with a Workbook
Question details
Keep custom fill colors available in Excel after saving and reopening a workbook, and reuse them in other files.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants a reusable palette of custom cell fill colors.
- Observed behavior
- Custom colors may no longer appear in the Fill Color drop-down after the workbook is reopened, even if existing cell fills remain.
Open the workbook in desktop Excel and identify the custom colors you want to reuse. If possible, record their RGB values from the Fill Color menu's More Colors option.
Add Custom Fill Colors to an Excel Theme
Use a custom theme palette to make selected colors available in the workbook and save the theme for other files.
A workbook stores its applied theme, while a separately saved theme file can be applied to other workbooks. The Fill Color menu's recent colors list is not a reliable saved palette.
Theme palettes have a limited number of color slots. Adding colors to a theme does not automatically convert existing custom fills into theme-based fills.
In Excel, open the workbook and select Page Layout > Colors > Customize Colors. Menu names may vary by Excel version.
Choose a theme color slot, select More Colors, and enter the desired RGB values on the Custom tab. Repeat for the colors you need, name the palette, and select Save.
Select the cells to format, then choose the new palette colors from Home > Fill Color > Theme Colors. Save the workbook.
Select Page Layout > Themes > Save Current Theme and save the theme file. In another workbook, use Page Layout > Themes to select the saved theme, or browse for its file.

Work with Formatted Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Excel format compatibility helps you move existing workbooks into WPS Spreadsheets, though it does not change how Excel saves its color themes.

Frequently Asked Questions
Why did my custom colors disappear from Excel's Fill Color menu?
The Recent Colors list may not persist after Excel is closed. Existing cell fills can remain in the workbook even when those colors no longer appear in the list. Add the colors to a theme palette to find them under Theme Colors.
Is an Excel theme saved inside the workbook?
The applied theme is stored with the workbook. To reuse the same theme in other files, select Page Layout > Themes > Save Current Theme and save a separate theme file.
How do I use my saved colors in another workbook?
Open the other workbook, select Page Layout > Themes, and choose your saved theme or browse for its file. The palette will then appear under Theme Colors in the Fill Color menu.
Will creating a theme change my existing custom fills?
Creating a theme does not automatically convert independently chosen custom fills into theme colors. To make a cell use a theme color, select the cell and choose that color from Home > Fill Color > Theme Colors.




