How to Enable Dark Mode in Microsoft Excel

Staring at a bright white grid of numbers and formulas for extended periods is a reliable way to develop eye strain and headaches, particularly during late-night work sessions. Fortunately, Microsoft Excel includes a native Dark Mode that transforms the application’s ribbons, menus, and toolbars into soothing shades of dark grey and charcoal. Understanding exactly how Excel’s dark mode works — and its one important limitation regarding the spreadsheet cells themselves — will help you get the most out of it.

How Excel’s Dark Mode Works

Excel uses Microsoft’s system-wide Office Theme setting to control its visual appearance. This theme affects the interface elements of the application: the ribbon at the top, the formula bar, the sidebar panels, the status bar at the bottom, and all menus and dialogs. However, there is an important distinction to understand: by default, the actual spreadsheet grid — the cells where you enter data — remain white even when dark mode is active.

How to Enable Dark Mode in Excel

Because this is an Office-wide setting, enabling it in Excel will simultaneously apply the dark aesthetic to Microsoft Word, PowerPoint, Outlook, and any other Office application you have installed.

1. Open Microsoft Excel on your Windows computer.
2. Click the File tab in the top-left corner of the ribbon.
3. At the bottom of the left-hand sidebar, click on Account. (Alternatively, click Options > General to find the same setting.)
4. Look for the section labelled Office Theme.
5. Click the dropdown menu and select one of the following options:
   • Dark Gray: A softer dark mode with medium-contrast dark tones. A good choice for working in moderately lit offices.
   • Black: The highest-contrast option, with near-black menus. Best for working in dark rooms.
   • Use system setting: Tells Excel to follow whatever appearance setting (Light or Dark) is currently active in your Windows 11 system settings. This option is ideal if you already have Windows set to switch to dark mode automatically at sunset.

Your changes apply instantly without requiring a restart.

How to Make the Spreadsheet Cells Dark

You will likely notice that even after applying the Black theme, the spreadsheet grid itself remains a bright white. This is a deliberate design choice by Microsoft, as keeping cells white ensures that cell highlighting colours, conditional formatting colours, and font colours display accurately and predictably.

If you want dark cells, you need to manually format the cell background colour:

1. Click the small triangle in the very top-left corner of the spreadsheet grid (the unmarked cell at the intersection of the row numbers and column letters) to select every cell in the workbook simultaneously.
2. Navigate to the Home tab in the ribbon.
3. Click the dropdown arrow next to the Fill Color bucket icon and choose a dark grey or near-black colour from the colour palette.
4. With all cells still selected, click the dropdown arrow next to the Font Color icon (the “A” with a colour bar) and change the text colour to white or a light grey so your data remains readable against the dark background.

Important consideration: If your spreadsheet uses conditional formatting rules that rely on specific cell background colours to communicate information (e.g., red for errors, green for success), manually setting the background colour will override those rules. Apply manual dark cell formatting only on spreadsheets where this will not cause confusion.