Office Settings & Configuration

Fix Excel 2021 Dark Mode Switch Not Working for Worksheets

Rana GarciaRana Garcia Nov 10, 2026 869 views

Question details

The user is unable to apply dark mode to Excel 2021 worksheet cells. The Switch Mode button is unresponsive despite the Black Office theme being active.

How to Fix Excel 2021 Dark Mode Switch Not Working
Product
Microsoft Excel 2021
Device & OS
Windows
Scenario
Attempting to change the worksheet canvas to dark mode using the Switch Mode button on the View tab.
Observed behavior
Worksheet cells remain white, and the Switch Mode button does not work even after updating, repairing, modifying the registry, and disabling add-ins.
Before you start

Ensure your Windows operating system and Microsoft Office suite are completely up to date, as some theme synchronization issues were resolved in recent patches.

Solution 1Recommended

Disable Windows High Contrast Mode

Windows High Contrast Mode overrides Excel's internal theme settings, causing the Switch Mode button to become unresponsive and locking the worksheet cells to a default color.

Excel's dark worksheet mode and Windows High Contrast Mode use different rendering priorities. When High Contrast is enabled for accessibility, Excel defers to system-level contrast settings, completely disabling the 'Switch Mode' toggle under the View tab.

1
Open Windows Settings

Press the Windows Key + I on your keyboard to open the Windows Settings application.

2
Navigate to Accessibility

Click on 'Accessibility' (or 'Ease of Access' in older Windows 10 versions) from the settings menu.

3
Turn Off Contrast Themes

Select 'Contrast themes' (or 'High contrast'). From the dropdown menu, select 'None' and click 'Apply', or turn off the High Contrast toggle switch.

4
Restart Microsoft Excel

Close all open instances of Microsoft Excel and relaunch the application to restore the functionality of the Switch Mode button.

Disable Windows High Contrast Mode
Theme Restoration: Once High Contrast is disabled, the 'Switch Mode' button on the View tab should instantly become clickable, allowing you to toggle the worksheet cells between black and white.
Free Microsoft Office alternative

Try WPS Office for a Flawless Dark Mode Experience

If Excel's dark mode settings continue to conflict with your Windows configuration, consider switching to WPS Office. It offers a dedicated Eye Protection Mode and Dark Theme that applies seamlessly to your spreadsheets without relying on complex system-level settings.

  1. 1. Download and Install: Visit the official WPS website, download the free installer, and complete the quick installation process.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open any existing Microsoft Excel file without losing formatting.
  3. 3. Enable Dark Mode Easily: Click the 'Eye Protection Mode' icon at the bottom status bar or select Dark Mode to instantly apply a comfortable dark background to your worksheet.
Built-in Eye Protection and Dark Mode that instantly turns spreadsheet backgrounds darkFully compatible with Microsoft Excel (.xlsx, .xls) file formatsLightweight architecture ensures fast loading and smooth scrollingFree to use with a familiar, highly intuitive ribbon interface
microsoft office alternative - wps office

Frequently Asked Questions

Are Excel themes and worksheet dark mode the same thing?

No. The 'Office Theme' changes the color of the ribbon, menus, and application borders. The 'Worksheet Dark Mode' specifically changes the actual cell background (the canvas) to a dark color. The Switch Mode button toggles the canvas color, but it only works if the Black Office theme is active.

Why is the 'Switch Mode' button grayed out on the View tab?

The Switch Mode button is only available when the Office Theme is specifically set to 'Black'. If your theme is set to 'Dark Gray', 'Colorful', or 'White', the button will be grayed out. Additionally, Windows High Contrast mode disables this button entirely.

Does changing my Windows 11 theme affect Excel's dark mode?

Yes, if your Excel Office Theme is set to 'Use system setting'. In this case, switching Windows 11 to Dark Mode will automatically switch Excel's UI to the Black theme, which in turn enables the dark canvas for worksheet cells.