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, 3× Microsoft Excel MVP and author of The Excel Theme Guide.Updated September 30, 2026.
In Excel for Microsoft 365 on Windows, 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. If one brand color is all you have to start from, the Color Studio will order the six accents for you.
Six practical steps
These menu steps are for Excel for Microsoft 365 on Windows. Theme-editing controls vary by platform; this is not a Mac or web menu guide.
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
With your colors and fonts active, choose Page Layout → Themes → Save Current Theme. Name the file and save it: the reusable Office theme is a .thmx file, separate from the workbook. Document the role of each accent.
Test the theme like a system
Open a second workbook. Choose Page Layout → Themes and select your saved theme under Custom. If you received a .thmx file or saved it elsewhere, choose Browse for Themes in the same menu and select that file. Check a six-series chart: theme-based series should use the six accents in order. Also check a shape with a manually assigned custom color; it may stay unchanged. A theme does not install fonts.
Menu reference: Microsoft’s theme-saving instructions and Excel’s apply/browse workflow.
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 printable reporting-system guide with a worked Excel example and tutorial, covering 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. Share the .thmx file and apply it through Page Layout → Themes → Browse for Themes in Windows Excel, or provide a correctly themed starter workbook. Test with your recipients and confirm they have the required fonts.
Reuse the rest of the dashboard design
A theme is one part of reuse. Learn how to adapt a complete template and carry slicer styles into a report.