My apologies. I have run out of options now.
Excel cells all display blank
After some MS update my Office 365 Excel stopped working correctly. All spread sheets don't display the values of any cells:
Notice the edit window displays "Weights" but the cell desplays blanks. This is how it displays on another computer:
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
14 answers
Sort by: Most helpful
-
-
Anonymous
2018-12-11T16:15:54+00:00 First, if you look at the cell format, you will probably find that the font color is white and the fill color is white.
The root cause is probably in the definition of the "Normal" style. I can provide directions for changing that in Excel 2010. But your posted screen images look very different from Excel 2010.
Before making any changes, make a backup copy of the Excel file, just in case you need to "undo" everything.
As a quick fix, press ctrl+a one or more times until all cells are selected. Then right-click and click Format Cells. First, click the Font tab and change the color to Automatic. Second, click the Fill tab and change the color to No Fill. Finally, click OK, and save the file.
Ideally, you would do something similar to correct the "Normal" style. In Excel 2010, I start by clicking Normal in the Style part of the toolbar. Again, I don't know if that works for your version of Excel, which looks very different.
-
Anonymous
2018-12-11T17:51:06+00:00 No it wasn't that, as it works fine on another computer. But it gave me the idea to try a different font.
It seems like it can't display the default "calibri" font. Almost any other font works.
Bryan
-
Anonymous
2018-12-11T18:22:02+00:00 I'm looking at how to restore that font. Not sure what else is missing.
Bryan