Excel comments not displaying

Anonymous
2017-01-22T11:53:30+00:00

I have excel 2016, and the comments have been working fine.  Just recently it does not display comments when I mouse over them. The show/hide command in the review tab is greyed out.  I never had this problem before, and never had to see if the comment show/hide feature was active or not.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

57 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2017-01-22T12:32:01+00:00
    • Go to File | Options | Advanced in you Excel program.
    • From the Display section Select the option Indicators only, and comments on hover
    • Click on Ok

    Was this answer helpful?

    40+ people found this answer helpful.
    0 comments
  2. Anonymous
    2017-01-22T14:14:12+00:00

    Thanks faysalMCC, I checked the settings you provided, and the radio button was already selected.  I de-selected it, and re-selected it, selected ok, and the situation is the same.  I can read the comments when I RMB and select show/hide, but they are always visible.  The mouse over functionality has always been working fine until I just noticed it this morning.  Any other thoughts???

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  3. Anonymous
    2017-01-22T14:47:51+00:00

    Can you please provide a snapshot?

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  4. Anonymous
    2017-01-22T15:16:56+00:00

    I closed everything down and restarted excel.  It's working now....  

    That was the trick is guess...

    Not sure what caused it,but it's gone.   

    Thanks for the help!

    Was this answer helpful?

    30+ people found this answer helpful.
    0 comments
  5. Anonymous
    2017-12-31T01:21:14+00:00

    I have a similar problem. Was working on a spreadsheet and mid-session the comment feature changed. When I hover over a cell, instead of seeing the comment box I see an arrow and a line. No box. When I select to edit the comment, the long line extends up to the top of the document and the box is compressed. Once I edit the comment and return to the cell, the comment feature behaves normally, but only for that cell. If I add new data & comment, everything works fine. But for all of the data that was in my document prior to the "change", I find I have to edit all the comments one by one to fix it.

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments