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

Recommended Productivity Software

Office Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010 and 2013 (includes Office 365).

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

Hint


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-comments1

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?


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-comments2

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

doc-show-hide-comments3-2doc-show-hide-comments4

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 Comment Tools 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 120 handy Excel add-ins, free to try with no limitation in 30 days. Get it Now.

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

1. Click Kutools > More > Cell Comment Tools, see screenshot:

doc-show-hide-comments5

2. In the Cell Comment Tools dialog box, click View button, and then select the settings that you need from the View comments option. See screenshot:

doc-show-hide-comments6

Notes:

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

(2.) If you check Indicator, all of the comment indicators in the workbook will be shown.

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

3. Then click Close button.

For more detailed information about Comment Tools, please visitCell Comment Tools feature description.


Related articles:


Is your problem solved?

Recommended Productivity Tools

The following tools will greatly save your time and effort, which one do you prefer?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: 120 powerful new functions for Excel, Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 More than 120 powerful advanced functions which designed for Excel:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase