May 18, 2015

MS Excel with phantom contents

This morning I came across a strange issue of not being able to view the contents of certain cells in an Excel spreadsheet. the selected cell did display the contents in the formula bar, but the cell itself showed blank. Did some quick google search and found others had faced similar issue. There were a few suggestions and seemed to work for some. It included selecting the cell / row and pressing crtl+B, essentially formatting the text. This worked for majority of the users with this problem. However, didn't work for me. Another suggestion seemingly working for a few others was to go to the View tab and selecting Arrange All>Tiled>OK. That didn't work for me either. Finally what worked for me was to selected the cells with invisible text and changing the font to another font. The issue seems to be with a corrupt font on your system. Well there you go, one of these solutions should work, please let me know if they didn't, thanks.