Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to show or hide all comments and comment indicators in Excel?

Usually, if we insert some comments in excel worksheet, the little red triangles will be displayed to indicate comments in cells, and when we hover over an indicator, the comments will displayed. How can we quickly show / hide comments or comment indicators in Excel?

Show or hide all comments with Show All Comments function

Show or hide both comments and comment indicators with Excel Options

Quickly show or hide both comments and comment indicators with one click


Auto-size Comment box to fit comment content:

With Kutools for Excel’s Autofit Comment utility, you can quickly auto adjust the comment box to fit its content in worksheet or the whole workbook.

doc show hide all comments 10

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


arrow blue right bubble Show or hide all comments with Show All Comments function


Using the following way to show or hide all the comments:

Click Review > Show All Comments, all of the comments have been displayed. Seen screenshot:

doc show hide all comments 1

If you click the Show All Comments button again, all of the comments will be hidden.

doc show hide all comments 2

This is a simple way to show or hide all comments, but if you want to hide the comment indicators, how can you do?


arrow blue right bubble Show or hide both comments and comment indicators with Excel Options

By default, when you insert the comments in excel, it will only display the comment indicators in cells. if you want to hide the comment indicators in Excel, you can hide the comment indicators with following steps:

1.Click File tab, and click Options.

2.In the Excel Options, click Advanced in the left panel, and then go to the Display section, in the group For cells with comments, show, check the No comments or indicators. See screenshot:

doc show hide all comments 3

3.Click OK. And all of the comments and indicators will be set to hide of all worksheets.

doc show hide all comments 4

And if you want to return the default state to display the comment indicators, please check Indicators only, and comments on hover in the above screenshot.

And checking the Comments and indicators option also can display all of the comments and indicators of the workbook.


arrow blue right bubble Quickly show or hide both comments and comment indicators with one click

With View Options tool of Kutools for Excel, you can easily set to display or hide the comments or comment indicators in Excel.

Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 60 days.

After installing Kutools for Excel, you can do as follows:

1. Click Kutools > Show / Hide > View Options, see screenshot:

doc show hide all comments 5

2. In the View Options dialog box, select the settings that you want to need from the Comments section.

(1.) If you check Comment indicator only, all of the comment indicators in the workbook will be shown.

doc show hide all comments 6

(2.) If you check None, all of the comments and indicators in the workbook will be hidden.

doc show hide all comments 7

(3.) If you check Comment & indicator, all of the comments and indicators in the workbook will be displayed.

doc show hide all comments 8

 Download and free trial Kutools for Excel Now !


Tips: Kutools for Excel contains various features of cell comments, you can apply them as your need, please look at the following screenshot:

doc show hide all comments 9


arrow blue right bubbleDemo: Quickly show or hide both comments and comment indicators with Kutools for Excel

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Related articles:



Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Dezignext Technologies · 5 months ago
    Keep in mind that the tutorials pertain to a specific plugin that can be downloaded for free. Kutools can provide some shortcuts for certain tasks that may save you some time when it comes to working with large amounts of data.
    • To post as a guest, your comment is unpublished.
      skyyang · 5 months ago
      Hi, Dezignext,
      Thank you for your support and encouragement, we will try our best to make the product more powerful.
  • To post as a guest, your comment is unpublished.
    Rocky Gupta · 1 years ago
    These excel shit step learning is really great and if provide the good knowledge and its system are great and it is very helpful and very supportive so thanks for sharing this post with us.
    Netflix Tech Support
  • To post as a guest, your comment is unpublished.
    Rocky Gupta · 1 years ago
    These excel shit step learning is really great and if provide the good knowledge and its system are great and it is very helpful and very supportive so thanks for sharing this post with us.
    Netflix Tech Support
  • To post as a guest, your comment is unpublished.
    Rebecca · 2 years ago
    This is super straight forward and very easy to read and understand!
  • To post as a guest, your comment is unpublished.
    michael mynch · 2 years ago
    Why can i not see the comments i have made