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

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.

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial.
kte tab 201905

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!
officetab bottom
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.
    Lisa · 2 months ago
    Thanks For share information if you are looking Support then click here
    Canada Tourist Visa

    Canada Pr Visa
  • To post as a guest, your comment is unpublished.
    Dezignext Technologies · 9 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 · 9 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 · 3 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 · 3 years ago
    Why can i not see the comments i have made
  • To post as a guest, your comment is unpublished.
    NortDog · 3 years ago
    Thank you. The 'Review-->Show Show All Comments' was the panacea. Excel help would have had me searching and searching. I forget I changed this setting!
  • To post as a guest, your comment is unpublished.
    Srose · 4 years ago
    Very helpful and well-displayed. Thanks!
  • To post as a guest, your comment is unpublished.
    fedex · 4 years ago
    its very helpful and .................................................................
  • To post as a guest, your comment is unpublished.
    kawi42 · 5 years ago
    Good summary. Thanks!
  • To post as a guest, your comment is unpublished.
    Rocky · 5 years ago
    Thank You...
    It was very helpful
  • To post as a guest, your comment is unpublished.
    J. Smith · 5 years ago
    Thank you, this was very helpful information!
  • To post as a guest, your comment is unpublished.
    cre · 5 years ago
    Paylaşım için teşekkürler elinize sağlık



    boyaci ustasi
    boyaci
    cati aktarma
    dekorasyon
    boya ustasi
    boyaci badana ustasi
    cati aktarma onarim
    dis cephe ustasi
    dis cephe boya boyama