Excel Dark Mode: Complete Setup Guide for Windows, Mac, and Web

Staring at a blinding white spreadsheet for eight hours straight is a recipe for tired eyes, headaches, and that strange feeling of being mildly hypnotized by your own data.

Excel dark mode flips the script. Instead of bright white cells punching photons into your retinas, you get a softer, darker palette that is friendlier on long working sessions and looks far more modern on contemporary monitors.

The feature has been quietly maturing across recent Microsoft 365 versions, and it now extends well beyond just the ribbon, reaching into the worksheet grid itself.

Most people who hunt for the setting find it within a few minutes, flip the toggle, and never look back. Others wrestle with quirks: chart backgrounds that stay stubbornly white, conditional formatting that suddenly looks washed out, or printed sheets that come out with inverted colors and waste a perfectly good toner cartridge.

This guide walks through every angle, from the basic toggle to the advanced tweaks that make dark mode actually usable for serious analysis work.

You will learn how to switch it on across Windows, Mac, the web app, and mobile, what changes in each version, and how to handle the edge cases that trip up power users. The shift to dark mode is not just cosmetic.

Studies on screen ergonomics suggest reduced eye fatigue during prolonged sessions, particularly in low-light environments. For analysts, accountants, and anyone living inside Excel for the better part of a workday, the difference between a glowing white canvas and a muted dark one can be the difference between finishing strong and quitting at 3 p.m. with a screen-induced headache.

Before you start clicking through menus, it helps to know which Excel version you are running. Dark mode behaviour differs noticeably between Excel 2019, Excel 2021, and Microsoft 365 subscription builds.

The most complete experience, including the dark worksheet grid that was rolled out in early 2024, is only available on Microsoft 365 builds version 2401 or later.

Older perpetual licenses offer a partial dark mode that styles the ribbon and surrounding chrome but leaves the cell grid white. If you are stuck on a legacy build, you will see references later in this guide to workarounds that get you closer to a true dark experience.

To check your version, click File, then Account, and look at the About Excel section. If you see a build number like 16.0.17231.20000 or higher, you have the full dark mode features.

Older numbers mean a partial implementation. IT-managed devices sometimes lag behind consumer installs because update channels are throttled by administrators. That is worth knowing before you blame the software for missing options.

Now to the actual procedure on Windows. Open Excel, click File in the top left corner, then click Account from the menu on the left.

You will see a section titled Office Theme with a dropdown. The options are typically Colorful (the default blue), Dark Gray, Black, White, and Use System Setting.

Choose Black for the deepest dark experience, or Dark Gray if you prefer slightly softer contrast. The change applies immediately to all Office apps, not just Excel, which means Word, PowerPoint, and Outlook will switch over too.

This is by design so the suite feels consistent. If you only want the ribbon dark but want to keep the worksheet grid white, choose Dark Gray instead of Black.

Older versions of Microsoft 365 stopped at the ribbon and left the cells alone. Newer versions let you go all the way. To activate the dark worksheet grid on Microsoft 365 build 2401 or newer, you need a second step.

Go to File, then Options, then General. Look for a section called Personalize your copy of Microsoft Office. Below that, you should see Office Theme set to Black already.

Below that there may be a toggle or a note about switching the spreadsheet grid to dark mode. On some builds, a banner appears at the top of the workbook asking if you want to switch to dark grid mode the first time you open it after upgrading.

If that banner does not appear, look for a small sun and moon icon near the top right of the worksheet area, just below the ribbon. Clicking it toggles the grid color.

Mac users get a smoother experience because Excel respects the system-wide appearance setting by default. If your Mac is set to Dark in System Settings, Excel arrives dark on first launch with no configuration needed.

To override this, open Excel, click Excel in the menu bar, then Preferences, then General. There is a Personalize section with a Office Theme option similar to Windows.

You can lock Excel to Light, Dark, or Auto. Auto follows the system. If you want Excel dark while the rest of your Mac stays light, set System Settings to Light and the Excel preference to Dark.

One quirk on Mac: certain chart elements and the formula bar may not pick up the dark theme cleanly in older builds. Microsoft has patched most of these issues in 2024 updates.

If you see white flashes around chart areas, check that you are running the latest update via the AutoUpdate tool. For Excel for the web, the path is different.

After signing in to office.com or outlook.com and opening any spreadsheet, look at the top right corner. Click the gear icon to open Settings. Under Theme or Appearance, select Dark.

The change is per-account, not per-device, so your browser theme will follow you across machines as long as you stay signed in. The web app has a slightly more limited dark experience than the desktop version, particularly around dialog boxes and the Power Query editor, which still tend to render in light mode.

Now the part that catches people off guard: charts, images, and conditional formatting do not automatically adapt to dark mode.

A chart you built six months ago with a white plot area will continue to display with a white plot area, sitting like a beacon on your otherwise dark sheet. This is intentional.

Microsoft prioritized backwards compatibility so your charts do not visually mutate when you switch themes. The downside is you need to manually update chart styles if you want them to blend in.

Right-click a chart, choose Format Chart Area, and set the fill to a dark gray or a custom color that complements the new theme. Save it as a template if you build many similar charts.

For pivot charts, the same logic applies, but you may also need to update the slicer styles which sit on top of the chart and have their own color logic. Conditional formatting is another area that needs attention.

Color scales designed for a white background can look murky on dark. Reds become muddy, greens turn olive, and the gradient loses its punch.

If conditional formatting is critical to your daily work, consider duplicating your rules and adjusting the color stops for higher contrast against the new dark grid. A common fix is to push the brightness of the high-end and low-end colors a notch up so the gradient remains readable.

Some users keep a parallel set of rules and switch them depending on which theme they are using that day.

The printing issue deserves more attention because it has burned more than a few unsuspecting users.

When you switch Excel to a dark theme, the default print behavior on most modern builds is sensible: it prints with white backgrounds and black text regardless of the on-screen theme. However, this is not universal.

Some older Microsoft 365 builds, particularly between version 2305 and 2310, had a bug where dark mode bled into printed output. If you are stuck on one of those builds, force a print preview every time and use the Page Setup dialog to verify the background is white.

Updating to the latest channel build solves this. Another print-related gotcha is exporting to PDF.

Excel for Windows generally exports to PDF with light backgrounds, but if you have manually set cell fills to dark gray, those will export as-is.

Make a copy of your worksheet for printing or PDF export, strip the dark cell fills, and export from the copy. It feels like extra work, but it is the only reliable way to get clean output across every Excel version.

Some teams build a small macro that toggles a print-friendly version of the sheet, clearing dark fills and restoring them afterward.

Once you have dark mode running smoothly, you may want to fine-tune the experience. The default dark gray cell background in Microsoft 365 sits around the hex value 222222 to 282828, depending on build.

Some users find this too dark and prefer a softer gray. While Excel does not expose a direct setting to change the grid background color, you can work around it by selecting all cells with Ctrl+A and applying a custom fill.

The downside is that this overrides the dynamic theme behavior, so if you ever switch back to light mode, you will have a dark sheet on a light theme. A better long-term solution is to use a custom theme color set.

Go to Page Layout, click Colors, and choose Customize Colors. Define a set you like and save it. From then on, your sheets pick up these colors as defaults.

Power users often pair dark mode with custom font choices. The default font, Aptos, renders well on dark backgrounds because of its slightly heavier strokes.

If you have switched to Calibri or another lighter font, increase the font size by one or two points to maintain readability. Anti-aliasing on Windows handles light text on dark backgrounds slightly differently than the reverse, and thin fonts can look fuzzy.

This is more pronounced on lower-resolution monitors. If you are on a high DPI display, you may not notice it at all, but on standard 1080p screens, the effect is real.

For accessibility users, dark mode interacts with high-contrast settings in interesting ways. Windows has its own high-contrast theme that takes precedence over Office Theme settings.

If you have enabled Windows high contrast mode for accessibility reasons, Excel will use Windows colors instead of its own dark palette. To check, open Windows Settings, go to Accessibility, then Contrast themes.

Make sure it is set to None unless you specifically need high-contrast support. If you do need it, expect Excel dark mode to look different than the standard Microsoft 365 dark experience.

If you are managing Excel across an organization, dark mode rollout is worth thinking about carefully. IT administrators can push the Office Theme setting via Group Policy or via the Microsoft 365 Apps admin center.

The setting name is UseDarkTheme or DefaultTheme depending on which deployment tool you use. Rolling out dark mode by default has been popular in late-shift call centers, financial trading floors that operate around the clock, and software development teams whose monitors are usually already running dark IDEs.

Users can still override the policy individually if it is set to user-configurable, which is the recommended deployment for most teams. One thing administrators sometimes overlook is the impact on training documentation.

Screenshots in your internal help wiki that were captured in light mode look out of place once everyone is on dark. If you keep a screenshot-based knowledge base, plan for a refresh after a dark mode rollout.

The same goes for training videos. New hires will be confused if your video tutorial shows a white grid while their actual Excel looks like outer space. Some teams record videos in both modes and let users pick.

Sticking with dark mode pays off after the first week. Your eyes adjust, your screen feels less aggressive, and that low hum of fatigue at the end of a workday tends to drop.

The setup work, particularly tweaking charts and conditional formatting, is a one-time tax. After that, the experience is just better, especially if you spend more than two or three hours a day in Excel.

Microsoft has signaled it intends to keep improving the dark experience, with the dark worksheet grid being the biggest leap so far. Future updates are expected to bring better chart auto-adaptation and smarter handling of imported objects.

For now, the manual work is worth it for what you get in return. Try it for a week, give your eyes time to adjust, and you will likely find it hard to go back to that searing white canvas.

One subtle benefit nobody mentions: dark mode tends to make typos and formatting mistakes more visible. The higher contrast between the light text and dark cells highlights small inconsistencies, like a stray space at the end of a value or a number that did not pick up the correct cell format.

This is anecdotal but worth noticing once you have spent time in both modes. Power users who do a lot of data cleanup sometimes specifically switch to dark mode for that reason.

If you collaborate on shared workbooks, your theme choice does not propagate to other users. Each person's Excel respects their own theme, which means the workbook itself is theme-agnostic.

That keeps collaboration friction-free. The only time you might run into trouble is if someone embeds an image of a chart that was screen-captured in dark mode, which would then look out of place on a light-themed viewer's machine.