Skip to main content

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

Author: Xiaoyang Last Modified: 2020-11-27

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

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:

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

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


Show or hide comments or comment indicators with one click

Kutools for Excel' View Options helps you to show or hide the comments or comment indicators in a worksheet or whole workbook. Please see the below demo.    Click to download Kutools for Excel!


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 the 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:

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

Tips: 1. If you want to return the default state to display the comment indicators, please check Indicators only, and comments on hover.

2.  Checking the Comments and indicators option can display all of the comments and indicators of the workbook.


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.

Tips:To apply this View Options feature, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily.

After installing Kutools for Excel, please do as this:

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

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.
  • (2.) If you check None, all of the comments and indicators in the workbook will be hidden.
  • (3.) If you check Comment & indicator, all of the comments and indicators in the workbook will be displayed.

Download and free trial Kutools for Excel Now!


Always show comment when the cell is selected with an amazing feature

Normally, we can hover the mouse to a cell for viewing the comment content, but, when the mouse cursor moved from the cell, the comment will be hidden at once. Is there any way to always show the comment content no matter the cursor is moved or not? The Kutools for Excel's Always Show Comment feature can solev this task quickly and easily.

Tips:To apply this Always Show Comment feature, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily.

After installing Kutools for Excel, please do as this:

Click Kutools > Show / Hide > Always Show Comment, see screenshot:

From now on, when clicking on a cell containing the comment, the comment content will always display no matter the cursor is moved or not.

Download and free trial Kutools for Excel Now!


Tips: Kutools for Excel also contains various features of cell comments, you can apply them as you need, please look at the following screenshot:
  • Create Comment List: will extract and list all comments into a new worksheet from the current sheet or whole workbook as you specified.
  • Convert Comment And Cell: convert between comments and cell contents quickly and easily.
  • AutoFit Comment: resize all comments to fit their contents accordingly in bulk in the active worksheet or the entire workbook.
  • Reset Comment Position: one click to reset all comments back to the default positions in the active worksheet or the whole workbook.
  • Read more features...         Download and free trial Kutools for Excel!

More relative comment articles:

  • List All Comments To A New Worksheet Or Workbook
  • If you have workbook with too many comments in it, and you want to list all comments to a new worksheet or workbook for reviewing all comments, how can ou do? The following methods can help you quickly list all comments of a worksheet / workbook to a new worksheet or workbook in Excel.
  • Change All Comments’ Author Name In Excel
  • When you insert the comments into a worksheet, the name of the comment author is automatically inserted into the comment followed by a colon. Sometimes, you may want to change the name of comment author. How can you do? You can change the name of comment author in Excel as the following methods.
  • Find And Replace Text Within Comments In Excel
  • When you insert the comments into a worksheet, the name of the comment author is automatically inserted into the comment followed by a colon. Sometimes, you may want to change the name of comment author. How can you do? You can change the name of comment author in Excel as the following methods.
  • Auto-Size Comment Box To Fit Its Content In Excel
  • When you insert the comments into a worksheet, the name of the comment author is automatically inserted into the comment followed by a colon. Sometimes, you may want to change the name of comment author. How can you do? You can change the name of comment author in Excel as the following methods.
  • Insert Picture Or Image In Comment In Excel
  • When you insert the comments into a worksheet, the name of the comment author is automatically inserted into the comment followed by a colon. Sometimes, you may want to change the name of comment author. How can you do? You can change the name of comment author in Excel as the following methods.

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, 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!
Comments (18)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Dankesehr!
This comment was minimized by the moderator on the site
<a href="https://ghrbiat.com"> موقع غربيات </a>
This comment was minimized by the moderator on the site
Very Impressive blog!! I loved your blog commenting mistakes related article.. i am gonna share you on my social media audience.
This comment was minimized by the moderator on the site
Thanks For share information if you are looking Support then click here
Canada Tourist Visa

Canada Pr Visa
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
Hi, Dezignext,
Thank you for your support and encouragement, we will try our best to make the product more powerful.
There are no comments posted here yet
Load More
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations