[Solved!] Comments Are Not Displaying Properly in Excel

Get FREE Advanced Excel Exercises with Solutions!

Among different kinds of not working problems in Excel, not working comment issues are a crucial issue. Excel’s comment feature is quite necessary and useful in our regular usage. So if it doesn’t work properly then it hampers our work and consumes time. If you are already facing this issue and searching for a source to overcome the situation then you have visited the right place. We are here to help you to solve the issue when comments are not displaying properly in Excel with 3 quick fixes.


Download Practice Workbook

You can download the free Excel workbook from here and practice independently.


3 Quick Fixes If Comments Are Not Displaying Properly in Excel

First of all, get introduced to our dataset that shows some books’ prices and publishing years. Look, Cell B5 and B9 are containing two comments.

Comments Are Not Displaying Properly in Excel


1. Mark Indicator Only, and Comments and Notes on Hover Option

The most frequent and common reason is maybe you or someone may have activated the No comments, notes, or indicators option from the Excel options. Look here at the dataset, the comments are no more. Let’s check the option and solve it.

Mark Indicator Only, and Comments and Notes on Hover Option to Display Comments

Solution:

  • Click on the File tab beside the Home tab.

Go to File Tab to Display Comments in Excel

  • Next, click on Options from the appeared menu.

Soon after, the Excel Options dialog box will open up.

Go to Excel Options

  • Select the Advanced menu.
  • Then scroll down and go to the Display section.

And look, the No comments, notes, or indicators option is activated here, that’s why no comments were displaying.

  • Now mark the Indicators only, and comments and notes on hover option.
  • Finally, just press OK.

Now see the comments are displaying properly.

Read More: Convert Comments to Notes in Excel (3 Suitable Ways)


Similar Readings


2. Escape from Active Cell in Excel

If you are in editing mode in Excel, meaning your cursor is active in a cell then maximum commands of Excel won’t work. So for this reason, the Show Comments option can be grayed out. Have a look at the image below, all the comments options are grayed out including the Show Comments option.

Escape from Active Cell in Excel to Display Comments

Solution:

  • Look, Cell C7 is active in our worksheet. Press the Esc button to release the cursor or click anywhere on the worksheet.

Escape from Active Cell in Excel by Releasing Cursor

Now see, the options are available, click on the Show Comments option and it will work.

All the comments are now visible.

Read More: How to Copy Comments to Another Cell in Excel (2 Methods)


3. Restart, Reinstall or Update the Excel App

Sometimes comments don’t display properly if the Excel app is not started or installed properly. This creates a lot of issues. Or maybe your Excel version is too older. In this situation, the above two solutions won’t work. First, reopen your excel app, if it doesn’t resolve the issue then reinstall or update the Excel app. Or if you are using a cracked version of Excel then it also may create the problem because the cracked version doesn’t work properly all the time, so try to use the genuine version. If these things fail to rescue you then let know your issue Microsoft Support team by mailing them, their expert team will solve the issue of your Excel app.


Conclusion

That’s all for the article. I hope the procedures described above will be good enough to fix the problem when comments are not displaying properly in Excel. Feel free to ask any question in the comment section and please give me feedback. Visit ExcelDemy to explore more.


Related Articles

Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo