How to Fix Excel Empty Cells Showing White Instead of No Fill
Question details
The user needs to restore an eye-friendly default background color for empty Excel cells that are incorrectly displaying as stark white after a system upgrade.
- Product
- Microsoft Excel
- Device & OS
- Windows 10
- Scenario
- Opening existing workbooks after upgrading to Windows 10 and reinstalling Microsoft Office.
- Observed behavior
- Cells formatted with 'No Fill' appear solid white rather than inheriting a comfortable Windows default window color, causing eye strain across multiple worksheets.
Before modifying your Windows system theme files, ensure you save any active workbooks and note down your current Windows theme name so you can easily reload it.
Modify Windows Theme Settings via Notepad
Adjust the system-wide 'Window' color in your Windows theme file to override the default white background for Excel's No Fill cells.
Because Excel relies on system colors to render 'No Fill' backgrounds, modifying the Windows theme file directly forces the application to use a customized, eye-friendly color like light gray. This prevents the need to manually reformat thousands of individual cells.
Open File Explorer and navigate to C:\Users\Username\AppData\Local\Microsoft\Windows\Themes, replacing 'Username' with your actual Windows account name.
Right-click the currently saved theme file and open it using Notepad.
Scroll to the end of the file. After the Recycle Bin entry, type '[Control Panel\Colors]' on a new line, followed by 'Window=197 197 197' on the next line (you can adjust these RGB values to your preferred color shade).
Save the file in Notepad and close the text editor.
Go to Windows Settings > Personalization > Themes. Select a different theme and wait for it to apply, then click on your modified original theme to reload the new color settings.
Experience an Eye-Friendly Spreadsheet Environment with WPS Office
If system upgrades have caused formatting issues and eye strain in your existing spreadsheets, try WPS Office. It handles cell shading independently of complex system theme files and features a built-in eye-protection mode, ensuring a comfortable viewing experience without modifying hidden Windows settings.
Frequently Asked Questions
Why are my Excel cells suddenly white after upgrading to Windows 10?
Windows 10 updated the default system window background color to pure white. Because Excel inherits the system's default 'Window' color for rendering cells with 'No Fill', your spreadsheets will automatically reflect this bright white background.
Can I fix this cell color issue without modifying Windows themes?
Yes, you can manually change the cell background by selecting the cells, navigating to the Home tab, clicking the Fill Color bucket, and choosing a light gray. However, this permanently modifies the actual document format rather than just adjusting your local viewing preference.
Will modifying the system theme affect other Microsoft Office applications?
Yes, adding the Window color parameter to your Windows theme file will change the default background color of other applications, such as Microsoft Word and Notepad, that also rely on the universal system window color setting.
