In Excel for Microsoft 365 on Windows, go to Page Layout > Themes > Colors and choose a color set to change the workbook’s theme colors. To create your own, choose Customize Colors, set the colors, and save the scheme. Theme colors update elements that use the workbook theme; they do not automatically replace every color applied manually to cells.
What You’ll Need
- Excel for Microsoft 365 on Windows. The main ribbon paths are similar in recent Excel versions for Mac, but the controls may look different. Excel for the web may not provide the full custom-theme workflow; open the workbook in the desktop app if you cannot find the needed commands.
- A workbook to update, plus the colors you want to use. If you are matching a brand palette, have its color values ready, preferably as RGB values.
- Permission to edit and save the workbook. If it is shared or read-only, you may need to save a separate copy first.
Step-by-Step
- Open and save the workbook. Open the file in Excel and save it before changing its appearance. If you need to preserve the original look, use File > Save As to make a copy. This gives you a safe version to return to if the new palette affects charts, tables, or other theme-based elements in an unexpected way. If the workbook is in a protected view, choose Enable Editing only if you trust the file and are allowed to change it.
- Find the theme color controls. Select the Page Layout tab. In the Themes group, open Colors. The gallery contains built-in color schemes and, depending on what has been used or installed, custom schemes. Hover over a choice to preview its effect in the workbook when live preview is available. Click a scheme to apply it.
- Check what the built-in scheme changes. Look at a few places that use theme colors, such as a chart, a shape, or a cell whose fill was selected from the Theme Colors area of the color palette. Theme-based accents should change to match the selected scheme. A cell with a manually chosen standard or custom fill may stay as it was. This difference is normal and helps you identify whether the item is linked to the theme.
- Open the custom color dialog. To make a scheme rather than use a preset, go back to Page Layout > Themes > Colors and select Customize Colors. Excel opens a dialog with slots for the theme’s text and background colors, six accent colors, and hyperlink colors. The labels identify what each slot is used for; the dialog may show a preview as you make selections.
- Set the theme colors one at a time. Open the color selector beside a slot, then choose a color from the available palette. For a precise brand match, choose More Colors if it appears and enter the RGB values supplied for that color. Set the dark and light text/background colors so text remains readable against the backgrounds where it will appear. Use the six accents for charts, shapes, SmartArt, and other highlighted items. Set hyperlink and followed-hyperlink colors so links remain easy to distinguish from ordinary text.
- Name and save the color set. Enter a clear name in the dialog’s name field, such as Project Brand Palette, then select Save. The new scheme should become the active color scheme in the workbook and appear among the available choices in the Colors gallery. Use a name that will make sense to colleagues too; names such as Custom 1 are difficult to identify later.
- Review and save the workbook. Inspect several worksheets, charts, and objects before saving. Check titles, labels, fills, and link colors, and make sure there is enough contrast for the content to remain readable. If you are happy with the result, use Ctrl+S on Windows. On Mac, use Command+S. If the new colors affect only some items, see the troubleshooting section before manually recoloring everything.
- Save the whole theme if you want to reuse it. A custom color set is useful in the current workbook, but saving the current theme makes it easier to carry the design to another file. In the desktop app, select Page Layout > Themes > Save Current Theme, choose a file name and location, and save the theme file. In another workbook, use Page Layout > Themes > Browse for Themes to find and apply the saved theme. A theme can include more than colors, so check fonts and effects too when applying it.
On Mac: Recent desktop versions generally offer theme and color controls from the Page Layout tab, but dialog labels and gallery layout can vary by release. Look for Themes and Colors; if a command is missing, update Excel or consult the version’s ribbon rather than assuming the workbook cannot use theme colors. In Excel for the web, use the desktop app for custom theme editing or saving a reusable theme when those options are unavailable in the browser.
Common Mistakes
- Expecting every cell to change: The theme controls the workbook palette, not every explicit formatting choice. If someone selected a fill from More Colors or applied a fixed font color, that formatting may not respond when the theme changes. Reapply a theme color to the item if you want it linked to the palette.
- Confusing the workbook palette with Excel’s interface appearance: Page Layout > Themes > Colors changes document colors. It does not change the Excel window’s overall light or dark interface. App appearance is a separate Office setting and may be managed through File > Account or Office preferences, depending on the installation.
- Using low-contrast combinations: A pale font on a light fill, or a dark font on a dark fill, can make worksheet information hard to read. Check text on both screen and print views, and do not rely on color alone to communicate an important status.
- Changing the palette without checking charts: Theme-based chart series can adopt new accent colors, which may change the meaning of familiar colors in a report. Review legends and labels after switching schemes, especially if readers associate a particular color with a category.
- Assuming a custom set is available in every file: Creating and saving a color scheme in a workbook is not the same as saving a reusable theme file. Save the current theme and apply it in the destination workbook when you need a repeatable setup.
Tips
- Plan the six accents before editing. These colors are used in many Office elements, including charts and shapes. Put the most important categories in the first accent slots if your workbook relies on default chart colors, then use the remaining slots for supporting categories.
- Keep a record of the palette. Write down the scheme name and RGB values in a project note or style guide. That makes it easier to recreate the palette if a workbook is copied, edited by someone else, or opened on another computer.
- Test on a representative sheet. Before changing a large reporting workbook, test the palette on a copy that includes a chart, a formatted table, hyperlinks, and shapes. This shows how the colors work across different content rather than only in a blank worksheet.
- Use theme colors for elements you expect to recolor later. When choosing a fill or font color, select from the Theme Colors section of the color menu instead of an unrelated standard color. Theme-linked formatting is easier to update consistently when the palette changes.
- Keep a backup theme file in a shared location. If coworkers need the same look, provide the saved theme file and its name or location. Ask them to apply it to their own workbook; changing your workbook’s theme does not automatically change other people’s files.
Troubleshooting
The Colors command is missing or unavailable. Confirm that you are in the desktop version of Excel and that the workbook is open for editing. The browser version has fewer design controls, and a simplified ribbon can hide commands. Expand the ribbon or open the file in the desktop app. If the workbook is protected or read-only, save an editable copy or ask the owner for permission.
The custom scheme does not appear after saving. Reopen Page Layout > Themes > Colors and check the custom section of the gallery. If you saved a full theme file instead, use Page Layout > Themes > Browse for Themes and navigate to the folder where you saved it. Make sure you are working in the workbook where you created the scheme; a color scheme is not automatically added to every workbook you open.
Some cells, charts, or shapes keep their old colors. These items may have direct formatting or may use a color that is not linked to the theme. Select the affected item and open its fill, font, or outline color menu. Choose a color from the Theme Colors area to link it to the active palette. For a chart, you can also select the chart and review its series formatting; changing the theme will not necessarily undo individual series colors that were set manually.
The new palette looks different on another computer. Confirm that the recipient opened the same workbook or applied the same saved theme, and check that no later formatting changes overrode theme colors. Theme colors themselves are stored with the workbook, but fonts, rendering, and manually applied colors can affect the overall appearance. Ask the recipient to open the file in a current desktop version of Excel and compare the same worksheet and chart.
The palette is hard to read or print. Return to Customize Colors and adjust the text and background slots, then review the key content again. Also check File > Print preview, since colors that look distinct on a screen may reproduce poorly in grayscale or on a particular printer. Use labels, patterns, or data markers as well as color where readers must tell categories apart.
Frequently Asked Questions
Will changing the color scheme recolor every worksheet cell?
No. It updates colors tied to the workbook theme, including many theme-formatted charts, shapes, and cells. Manually chosen colors may remain unchanged. To make an item follow the scheme, select a theme color for its fill, font, or outline.
Can I change only one color in the scheme?
Yes. Open Page Layout > Themes > Colors > Customize Colors, change the relevant slot, and save the scheme. Remember that a slot can be used in several places, so changing an accent may affect multiple charts or objects.
Does changing the color scheme change Excel’s dark mode?
No. The workbook color scheme controls document colors. Excel’s application appearance is a separate setting. Changing one does not necessarily change the other.
Can I use the same custom colors in another workbook?
Yes. Save the current theme with Page Layout > Themes > Save Current Theme, then open the other workbook and use Browse for Themes to apply the saved file. Review the result because a theme can also contain font and effect settings.
Can I change a workbook’s color scheme in Excel for the web?
Some web builds offer theme choices, but the full custom-color and reusable-theme commands may be absent. If you cannot find Customize Colors or Save Current Theme, open the workbook in Excel for Windows or Mac, make the change there, and save it.
Why did my chart colors change after I selected a scheme?
The chart likely uses theme colors for its series. A new scheme can assign different colors to those series. If the colors carry meaning, review the legend and either choose a scheme with appropriate accents or format the chart series individually after changing the theme.
Related
- How to Align Text in Excel Without Merging Cells
- Align a Page in Excel for Printing: Center and Position
- How to Align a Picture in an Excel Cell: Step by Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Undo Shortcut: Ctrl+Z and How It WorksIn Excel for Microsoft 365 on Windows, press Ctrl+Z to undo your most recent action; on a Mac,…
- Excel Not Responding and Not in Task ManagerIf Excel says Not Responding but you cannot find it in Task Manager, first check the Processes and…
- How to Exit Track Changes in Word Without Losing EditsTo exit Track Changes in Word, open the Review tab and switch Track Changes off. This stops Word…
- Splinter Cell Split Jump: How the Wall Move Works in the GamesA Splinter Cell split jump is a move in which Sam Fisher jumps up in a narrow passage…
- How to Convert Text to Numbers in an Excel ColumnTo convert text-formatted numbers in an Excel column, select the cells, click the warning icon that appears beside…
- Excel Set Print Area to Fit on One Page: Steps and TipsTo set an Excel print area and fit it on one page, select the cells you want, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.