Formula bar display - data is there but not visible
Posted on 2016-09-23
My excel 2013 suddenly stopped displaying the values or formulas in the formula bar. The data or formula associated with a cell are there, just cannot be seen. You can select the info in the formula bar and then paste it into another cell, which will then display. I can click in the cell and edit, but still nothing visible is displayed in formula bar.
Looked here and in other forums for a solution. I've checked to make sure "hidden" and "protection" of the cell or sheets are not selected incorrectly. I am using a multiple display, but switching back to single did not resolve the issue. I've expanded the formula bar and looked for any line returns. I've removed the formula bar and added it back. I've tried to change the font and font color of the contents of the formula bar.
It is affecting all the worksheets I have open, not just one. I have looked through the "File\options" for any settings I may have inadvertently changed but without success.
Any help would be appreciated!