This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
Check my earlier response.
Microsoft is unable to fix the bug.
You can create a new file, and copy all the info and paste it on to the new sheet. It then works, and the comments display when you hover over it.
I have noticed the comments have changed in Excel, so now one can't show comments permanently as an option on every individual comment.
Anyone know how to fix it so it works like the older version for Excel? The change happened in late December 2018...
thx!
I think I have fixed this, at least in terms of "Comments" vs "Notes". I can't comment on any Mac related issues as I am using Excel under an Office 365 subscription using Windows 10.
I had created my Comment by right-clicking on a cell and selecting to add a Comment. Whenever I had done this previously, a yellow box would appear with my username at the top to which I could add my text. Then, once created, I could permanently Show or Hide this using a new menu option which now appeared when right-clicking the relevant cell.
I did the same this morning, but the yellow box didn't appear. Instead, you get the style of comment which you see in Word, in a grey box with a text field.
After some exploration of this thread and looking at my version of Excel, Microsoft appear to have renamed the older yellow box style "Comments" to "Notes".
If you create a "Note", you will create the yellow box we used to understand to be a Comment which can then be permanently shown or hidden.
Hope this helps!
Neil
Yes it does, THX!
Have a nice weekend :)