excel spreadsheet colors

Question

Can't view colors in my excel spreadsheet. Colors print fine

Answer 1

Hello GuyandCyndiGleason-6608,

I see that you're having trouble viewing colors in your Excel spreadsheet on screen, even though they print correctly. This is typically a display setting issue rather than a problem with the spreadsheet itself.

Here are some quick troubleshooting steps:

1. Check Display Settings - Go to File > Options > Advanced, and look for "Printing options" or display-related settings
2. Disable Hardware Acceleration - File > Options > Advanced > Display, then uncheck "Disable hardware graphics acceleration"
3. Update Your Graphics Driver - Outdated drivers can cause display issues
4. Try Safe Mode - Launch Excel in Safe Mode to see if add-ins are interfering
5. Check View Mode - Ensure you're not in a special view mode that hides colors

If it still not works out for you, please let me know so I can help you further:

1. Which version of Excel are you using? (Excel 2021, Microsoft 365, Excel Online, etc.)
2. When did this problem start? (After an update, installation, or has it always been like this?)
3. Are ALL colors not displaying, or just specific ones? (Like conditional formatting colors, cell fill colors, font colors, etc.)
4. Does this happen in all spreadsheets or just specific ones? Please capture it if you could.

I hope this will help with your situation. Please feel free to reach back if you have further update or more questions.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

In Excel, if colors print correctly but are not visible on the screen, the worksheet is likely being displayed in a high contrast or similar accessibility mode that removes colors.

Excel notes that if colors are not visible in the worksheet (but do appear when printed), it may be because the system is working in high contrast mode. In this case, cell fill colors and shading will not show on screen even though they still exist and print correctly.

Disable high contrast or any color filters/contrast themes in Windows, then reopen Excel and the workbook. Once high contrast is off, the background colors and shading should be visible again in the spreadsheet, just as they appear on the printout.

---

References:

• Add or change the background color of cells in Excel
• Apply or remove cell shading in Excel