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
31 Answer
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.