How to create a custom Excel theme
Put your colors and fonts into Excel's actual theme controls so new charts, tables, shapes, and text begin in the right system—instead of being repaired one object at a time.
By Joshua Cottrell-Schloemer, 2× Microsoft Excel MVP and author of The Excel Theme Guide.In Excel, go to Page Layout → Colors → Customize Colors, assign the four neutral/text-background slots, six Accent colors, and two hyperlink colors, then save the palette. Use Page Layout → Fonts → Customize Fonts to set heading and body fonts. Test the result on charts, tables, shapes, and links before distributing it.
A palette is a list. A theme changes behavior.
Pasting hex codes into a hidden sheet gives people a reference. A custom theme puts those colors into Excel's menus and makes theme-aware objects respond to the system. New charts can pull their series from Accent 1 through Accent 6. Text can use theme fonts. If the organization changes a brand color, a theme-aware workbook can update far more consistently than one built from dozens of unrelated custom fills.
The theme is not the design by itself. It is the foundation that makes consistent design faster. The important work is deciding what each slot should do before entering the values.
What the Excel theme color slots control
| Theme slots | Practical role | What to watch |
|---|---|---|
| Dark 1 / Light 1 | Primary text and primary background pair. | These need strong contrast because Office may use them automatically. |
| Dark 2 / Light 2 | Secondary dark and light surfaces or text. | Do not make both pairs so similar that the hierarchy disappears. |
| Accent 1–6 | Chart series, table styles, shapes, and emphasis colors. | Order matters. Many charts assign series in this sequence. |
| Hyperlink / Followed Hyperlink | Link states. | Keep links recognizable and readable on the workbook background. |
Accent 1 is usually the most important brand color. But the remaining accents should not be random leftovers. They need enough separation to work as adjacent chart series, and they should remain usable for people with common forms of color-vision deficiency. If you only need one emphasis color in the interface, that is fine—the other accents still matter when Excel builds a multi-series chart.
Six practical steps
Inventory the brand
Collect approved colors, heading and body fonts, accessibility rules, and a few real reports the theme must support.
Assign the slots
Choose two light/dark pairs, order six accents deliberately, and select clear hyperlink colors.
Enter the colors
Open Page Layout → Colors → Customize Colors. Enter the RGB values for each slot and give the palette a recognizable name.
Set the fonts
Open Page Layout → Fonts → Customize Fonts. Choose a heading and body family that recipients are likely to have installed.
Test real objects
Create charts, a formatted Table, shapes, headings, links, and both light and dark surfaces. Look for collisions and poor contrast.
Save and document
Save the theme, then explain the role of each accent so users do not treat every available color as equally appropriate.
Test the theme like a system
Common Excel theme mistakes
A theme is not a complete design system
An Office theme gives you reusable colors, fonts, and effects. A useful reporting system also needs spacing, chart selection rules, number formats, title conventions, KPI-card anatomy, accessibility standards, and example layouts. It needs a decision about when status colors override the brand and when a chart should stay neutral.
If you only need a better starting palette, use the free Data-Viz Color Studio to build and export an Office theme. If you are setting up a repeatable branded reporting system, the Excel Theme Guide goes deeper into the theme architecture and the design choices around it.
The Excel Theme Guide
A 14-page system for creating consistent Excel reports, with the theme-driven workflow, color and type decisions, and practical structure behind reusable dashboard design.
Custom themes in Excel
How do I make a custom color theme?
Open Page Layout, choose Colors, then Customize Colors. Assign the Dark, Light, Accent 1 through Accent 6, and hyperlink slots, name the palette, and save it.
Why do chart colors change when I apply a theme?
Charts commonly draw series from Accent 1 through Accent 6. Changing the theme remaps theme-aware chart elements. Manually assigned colors may not update.
Does a theme include cell styles and layouts?
A theme mainly defines colors, fonts, and effects. A complete design system also needs layout, spacing, chart rules, number formats, components, and usage guidance.
Can I share the theme?
Yes, but test the workflow for your recipients and provide the theme or a correctly themed starter workbook. Confirm everyone has the required fonts.