0

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

Improve this question
3
  • 3
    Welcome to Super User! Some screen shots of your data would help us understand your question. Upload any image(s) to Imgur and you will get link(s) you can share. Edit your question to include the link(s) and someone with sufficient reputation will inline the image(s) for you.
    – DavidPostill ♦
    Aug 8, 2018 at 14:26
  • If you select a cell with data, but the formula bar shows the cell address, and you start typing in that cell, does the correct data you enter show up in the formula bar? Or is it still "blank"? Or, select a cell with contents where the formula bar shows the address, and press F2. Does the formula bar correct itself then? A screenshot would help.
    – BruceWayne
    Aug 8, 2018 at 16:14
  • 1
    Are you sure you are talking about the formula bar and not the name box?
    – cybernetic.nomad
    Aug 8, 2018 at 16:20

1 Answer 1

Reset to default
1

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.

enter image description here

Improve this answer

Not the answer you're looking for? Browse other questions tagged .