Fix Excel 2021 Dark Mode Switch Not Working for Worksheets
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.

- 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.
Ensure your Windows operating system and Microsoft Office suite are completely up to date, as some theme synchronization issues were resolved in recent patches.
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.
Press the Windows Key + I on your keyboard to open the Windows Settings application.
Click on 'Accessibility' (or 'Ease of Access' in older Windows 10 versions) from the settings menu.
Select 'Contrast themes' (or 'High contrast'). From the dropdown menu, select 'None' and click 'Apply', or turn off the High Contrast toggle switch.
Close all open instances of Microsoft Excel and relaunch the application to restore the functionality of the Switch Mode button.

Verify Office Theme and Canvas Settings
Check if Excel's specific setting that forces the document canvas to remain light is accidentally checked in the application options.
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. Download and Install: Visit the official WPS website, download the free installer, and complete the quick installation process.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open any existing Microsoft Excel file without losing formatting.
- 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.

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.




