Excel guide · 4 min read
How to turn on dark mode in Excel
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C |
|---|---|---|---|
| 1 | What you want | Setting | Where |
| 2 | Dark ribbon and menus | Office Theme: Black or Dark Gray | File > Account > Office Theme |
| 3 | Excel to follow Windows | Office Theme: Use system setting | File > Account > Office Theme |
| 4 | Dark cells too (Microsoft 365, Windows) | Black theme, then Switch Modes | View tab |
| 5 | Light cells, dark ribbon | Switch Modes again | View tab |
| 6 | Excel light while the Mac is dark | Turn off Dark Mode | Excel > Settings > General |
| 7 | Everything back to normal | Office Theme: Colorful or White | File > Account > Office Theme |
1. Make the ribbon and menus dark: Office Theme
Office Theme controls the colour of everything around the grid. It's shared by all Office apps on that computer, so changing it in Excel changes Word, PowerPoint and Outlook too.
- Click File, then Account (bottom left).
- Open the Office Theme drop-down.
- Pick Black for the darkest look, or Dark Gray for a softer one. Colorful and White are the light options.
- The change applies straight away; no restart needed.
2. Why the cells are still white
For years, Office Theme only changed the frame. The grid stayed white whatever you picked, which is what most people are still looking at when they search for this. Older versions (Excel 2016, 2019, 2021) work this way and have no setting for dark cells.
Microsoft 365 on Windows added a dark worksheet as well. It needs two things: the Black theme (or Use system setting with Windows itself in dark mode), and the Switch Modes button on the View tab. If you can't see Switch Modes, your Excel doesn't have the feature yet: update it from File > Account > Update Options > Update Now, and check that you're on the Windows app rather than Excel for the web or Mac.
- Set Office Theme to Black (step 1).
- Go to the View tab and click Switch Modes. The cells turn dark and text turns light.
- Click Switch Modes again whenever you want white cells back while keeping the dark ribbon.
3. What dark mode does and doesn't change
Dark mode is a display setting on your computer. It doesn't change the file. Microsoft's documentation says the workbook prints with the normal light page, and people you share it with see it in whatever mode they've chosen.
Colours are adjusted for display, so cell fills and font colours can look different from how they really are. Before you send a colour-coded report or judge whether highlighting is readable, flip back to light with Switch Modes and check it.
Don't fake dark mode by filling every cell black and making the font white. That is saved in the file, it prints (using lots of ink) and everyone else sees it too.
4. Windows dark mode doesn't change Excel? Check "Use system setting"
Turning on dark mode in Windows Settings > Personalization > Colors only affects Excel if Office Theme is set to Use system setting. If someone picked Colorful or White in the past, Office keeps that choice and ignores Windows.
Set File > Account > Office Theme to Use system setting and Excel will follow Windows from then on, switching when you switch. The reverse also applies: if Excel went dark on its own after a Windows update or a change in Windows settings, this is why. Pick White or Colorful to keep Office light whatever Windows does.
5. Excel for Mac
On a Mac, Excel follows the system appearance set in System Settings > Appearance. Choosing Dark there darkens Excel's ribbon and menus; the worksheet stays light.
To keep Excel light while the rest of the Mac is dark, go to Excel > Settings (Preferences in older versions) > General and tick Turn off Dark Mode. Like the Windows theme, it's for your screen only.
Common mistakes
Expecting Dark Gray to darken the cells
Only the Black theme unlocks dark cells, and only with View > Switch Modes in Microsoft 365 for Windows.
Changing Windows dark mode and waiting
Office follows Windows only when Office Theme is Use system setting. Set it in File > Account.
Filling cells black to get a dark sheet
That changes the file, prints and affects everyone. Use the display settings instead.
Checking report colours in dark mode
Display colours are adjusted. Switch back to light before judging fills, font colours or contrast.
FAQ
How do I make Excel cells dark?
In Excel for Microsoft 365 on Windows, set File > Account > Office Theme to Black, then click View > Switch Modes. Older versions and Excel for Mac only darken the ribbon, not the cells.
Why is there no Switch Modes button in my Excel?
It needs a current Microsoft 365 version on Windows and the Black theme (or Use system setting with Windows dark). Update Excel from File > Account > Update Options and check the theme.
Does Excel dark mode affect printing?
No. The sheet prints with a white page and its real colours. Dark mode is only how your screen shows it.
How do I turn off dark mode in Excel?
Click View > Switch Modes to get white cells back, and set File > Account > Office Theme to Colorful or White to make the ribbon light. On a Mac, tick Turn off Dark Mode in Excel's General settings.
Related guides
- Excel gridlines not showing (or missing in some cells): how to get them back
- Excel ribbon missing: how to get it back
- Excel formula bar missing or not showing: how to get it back
- Excel sheet tabs missing: how to show them again
Updated