Excel's default color is white, and you can change it through theme settings or by creating a custom template

Excel does not have a single "default color" button. Instead, the background color of your spreadsheet comes from the active theme, and you can change it in two ways: by switching to a built-in theme, or by creating a custom template that opens with your preferred colors every time. The method you choose depends on whether you want to change the color for one file or for all new files you create going forward.

Reddit users often ask this question because they find the bright white background tiring or want their spreadsheets to match their computer's dark mode. The good news is that both approaches take less than five minutes.

Key Takeaways

  • Built-in themes in Excel change the background color, font colors, and accent colors all at once — you access them through the Page Layout tab.
  • Changing a theme affects only the file you are currently working on, not future spreadsheets you create.
  • To make a color change permanent across all new files, you must create a custom template and set it as your default.
  • Dark mode on your computer does not automatically change Excel's spreadsheet background — you have to change the theme or template separately.
  • Some color changes require you to format individual cells rather than changing the theme, depending on what you want to alter.

Using built-in themes to change spreadsheet colors

The fastest way to change the overall color of your spreadsheet is to use Excel's built-in themes. Open your spreadsheet, then click the Page Layout tab at the top of the ribbon. Look for the Themes button — it usually shows a small palette icon. Click it to see a list of pre-made themes with names like "Office," "Grayscale," "Blue Warm," and "Ion."

Each theme changes not just the background but also the default font colors and accent colors throughout your spreadsheet. Click any theme to apply it instantly. The change affects only the file you are currently working on. If you close the file and open a different one, that new file will still use Excel's standard white background unless you apply a theme to it as well.

If none of the built-in themes match what you want, you can also right-click on any theme and select Edit to customize its colors. This opens a dialog where you can change individual color elements — but this still only affects the current file.

Creating a custom template to set a permanent default

If you want every new spreadsheet you create to open with your preferred color, you need to create a custom template. Start by opening a blank spreadsheet and applying the theme or colors you want. Format the cells, change fonts, adjust column widths — make it look exactly how you want your default spreadsheet to look.

Once you have set up the spreadsheet the way you want it, click File, then Save As. In the dialog that opens, change the file type dropdown from "Excel Workbook" to Excel Template (the option will say ".xltx"). Name the file something clear like "My Default Template." Excel will automatically save it to your Templates folder.

Now, whenever you create a new spreadsheet, click File and then New. Instead of clicking "Blank Workbook," look for Personal or My Templates at the top of the screen. Your custom template will appear there. Click it to open a new spreadsheet with your colors already applied.

Changing cell background colors individually

If you want to change the background color of specific cells rather than the entire spreadsheet, select the cells you want to format. Right-click and choose Format Cells, or press Ctrl+1 on Windows or Command+1 on Mac. Click the Fill tab, then choose your color from the palette.

You can also use the paint bucket icon in the toolbar. Select your cells, click the small arrow next to the paint bucket, and choose a color. This method is faster for quick changes but does not affect the overall theme of your spreadsheet.

Why dark mode on your computer does not change Excel automatically

Many people turn on dark mode in Windows or macOS expecting Excel to follow suit. Excel does not automatically switch to dark colors when your operating system does. The spreadsheet background remains white unless you manually change the theme or create a dark template.

If you want a dark spreadsheet, apply one of the darker built-in themes like "Grayscale" or "Ion," or create a custom template with a dark background. Some users also use the Accessibility settings in Excel to adjust contrast, though this is a different feature from changing the background color itself.

Saving your color changes so they stick

When you apply a theme to a spreadsheet and then save the file, the theme stays with that file. The next time you open it, the colors will be there. However, if you want the color to be your default for all future spreadsheets, you must create and use a custom template as described above.

If you have already created a spreadsheet with colors you like and want to use it as your template going forward, you can convert it. Open the file, click File and Save As, change the file type to Excel Template, and save it. Then use that template when you create new files.

Common reasons color changes do not appear

If you apply a theme and the colors do not show up the way you expected, check whether your printer settings are overriding the display. Some users have "Print Preview" mode on, which shows how the spreadsheet will look when printed — and many printers ignore background colors by default to save ink. Click File and make sure you are not in Print Preview.

Another common issue is that themes change the accent colors and font colors but not the cell background itself. If you want a colored background behind all your data, you may need to select all cells and manually apply a fill color, or create a template with that background already in place.

Frequently Asked Questions

Can I make Excel open in dark mode by default?

Excel does not have a built-in dark mode that syncs with your operating system. You can create a custom template with a dark background color and use that template when you create new files, but you will need to do this manually for each new spreadsheet.

Will changing the theme affect my data or formulas?

No. Themes only change colors and fonts. Your data, formulas, and calculations remain exactly the same. You can change themes as many times as you want without losing any information.

How do I change the color of just the column headers?

Select the header row, right-click, choose Format Cells, click the Fill tab, and pick a color. This lets you color headers differently from the rest of your spreadsheet without affecting the overall theme.

If I create a custom template, will it work on both Windows and Mac?

Yes. Save your template as an Excel Template file (.xltx), and it will work on both platforms. The template will appear in your Personal Templates folder on whichever computer you save it to.

Can I undo a theme change?

Yes. Click Page Layout, then Themes, and select Office to return to Excel's standard theme. Or press Ctrl+Z to undo the change immediately after applying the theme.