How to Hide Comments in Microsoft Excel - WindowsTips.net - Windows Tips and Tricks with Geek

Wednesday, November 3, 2021

How to Hide Comments in Microsoft Excel

Hide Comments

When you add a comment to a cell in Excel, a small red triangle displays in the upper-right corner of the cell to indicate a comment was added. When you hover your mouse over the cell, or select the cell, the comment displays in a popup window.

If you have a lot of comments in your worksheet, you may not want to see the red triangles and have comments popup as you move your mouse around the worksheet. To hide the comments, click the “File” tab.

On the backstage screen, click “Options” in the list of items on the left.

On the “Excel Options” dialog box, click “Advanced” in the list of items on the left.

Scroll down to the “Display” section. Under “For cells with comments, show”, select the “No comments or indicators” radio button.

Click “OK” to accept the change and close the “Excel Options” dialog box.

The red triangles and comment popup windows are now hidden.

The comments are still associated with their respective cells and can be viewed by clicking the “Review” tab and clicking “Show All Comments” in the “Comments” section.

All the comments in your worksheet are displayed without having to hover over the cells. To hide the comment popup windows, click “Show All Comments” again. The comment popup windows are hidden but the red triangles remain visible.

NOTE: If you want to show or hide a comment for a certain cell, select that cell and click “Show/Hide Comment” in the “Comments” section of the “Review” tab. You can select multiple cells with comments using the “Ctrl” key to show or hide the comments on those cells only.

Clicking the “Show All Comments” button so it toggles off changes the “For cells with comments, show” option back to “Indicators only, and comments on hover” automatically.

No comments:

Post a Comment