'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel for the Web Dark Mode and Cell Display Issues
Question details
Users need to resolve display and formatting conflicts, such as black cells or incorrectly inverted colors, when viewing Excel files online with browser dark mode enabled.
- Product
- Excel for the Web, SharePoint Online
- Device & OS
- not provided
- Scenario
- Viewing or editing Excel spreadsheets in a web browser or Outlook where a system or browser-level dark theme is active.
- Observed behavior
- Excel for the web and SharePoint do not have a dedicated dark mode, causing light and dark content to display inconsistently or cell backgrounds to turn black when forced by browser settings.
Before troubleshooting, check if you have any third-party dark mode extensions enabled in your web browser, as these can force color inversion and cause formatting conflicts in web apps.
Open the File in the Desktop Version of Excel
Since Excel for the Web lacks a native dark mode, using the desktop application ensures your formatting and cell colors display exactly as intended without browser interference.
Microsoft currently considers this behavior by design because there is no global dark-mode setting for all SharePoint sites, nor a dedicated dark mode in Excel for the Web.
Navigate to SharePoint or Office.com and open the affected Excel file in your web browser.
Look for the 'Viewing' or 'Editing' dropdown menu on the top ribbon interface.
Select 'Open in Desktop App' from the menu. The file will open in your locally installed Excel application, displaying the original formatting correctly.
Disable Browser Dark Mode or Extensions
Prevent forced color inversion by turning off dark mode settings or extensions specifically for SharePoint and Office web apps.
Experience Consistent Formatting with WPS Office
Tired of web browser display glitches and missing features in Excel for the Web? WPS Office provides a lightweight, highly compatible desktop alternative with built-in eye protection features, ensuring your spreadsheets look perfect every time.
- 1. Download WPS Office: Visit the official WPS website and install the free WPS Office suite on your computer.
- 2. Open your spreadsheet: Launch WPS Spreadsheet and open your downloaded Excel (.xlsx) file to view it with native formatting.
- 3. Enable Eye Protection Mode: Navigate to the 'View' tab or look at the bottom status bar to easily toggle 'Eye Protection Mode' or 'Dark Mode' for a comfortable, consistent visual experience.
Frequently Asked Questions
Why are my Excel cells showing up black in SharePoint?
This typically happens when your web browser, operating system, or a dark-mode extension forces a color inversion on Excel for the Web, which currently does not natively support its own dark mode theme.
Can I turn on Dark Mode specifically for Excel for the Web?
No, Microsoft has not yet introduced a dedicated dark-mode setting for Excel for the Web. Any dark themes currently applied are forced by external browser or system settings.
How do I ensure my spreadsheet colors look normal for all viewers?
To guarantee that formatting and colors display accurately for everyone, advise users to open the file using the desktop version of Excel or use a dedicated desktop alternative like WPS Office.
