Formatting Issues

Save Custom Excel Fill Colors with a Workbook

Muhammad TalhaMuhammad Talha Nov 13, 2026 869 views

Question details

Keep custom fill colors available in Excel after saving and reopening a workbook, and reuse them in other files.

How to Save Custom Excel Fill Colors with a Workbook
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the color settings

In Excel, open the workbook and select Page Layout > Colors > Customize Colors. Menu names may vary by Excel version.

2
Define the palette

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.

3
Apply the theme colors

Select the cells to format, then choose the new palette colors from Home > Fill Color > Theme Colors. Save the workbook.

4
Save the theme for reuse

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.

Add Custom Fill Colors to an Excel Theme
Check the Theme Colors section: After reopening the workbook, look under Theme Colors in the Fill Color drop-down rather than relying on Recent Colors.
Free Microsoft Office alternative

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.

Apply cell fill colors and format spreadsheets in WPS SpreadsheetsOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar interface for a smoother transition from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

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.