My excel version 16.15 shows cell address in the formula bar. It does not show cell content or formulas. I have turned the formula bar on and off and checked preferences for hints, but I can't figure it out. Thank you

If you format cells. The Hidden checkbox will mean that when a sheet is protected, the formulas will not be visible. You can un-protect the sheet, remove the Hidden check, or both, depending on how you use the sheet.

`F2`

. Does the formula bar correct itself then? A screenshot would help. – BruceWayne Aug 8 '18 at 16:14