A friend called last week asking if there was any way to hide both comments and the red triangles that indicate comments in Excel. I knew how to hide the comments, but I wasn’t even sure there would be a way to hide the triangles.  Turns out there is.  But before we get to hiding comments, let’s start with inserting a comment.

Insert a Comment

  1. Select the cell to which you’d like to add a comment.
  2. Click on the Review tab of the ribbon.
  3. Click on the New Comment button.
  4. A new comment will appear.  Type your comment.
  5. Click on a cell outside the comment to finish it.

Hide Comments (But Not Comment Indicators)

  1. Click on the Review tab of the ribbon.
  2. Click Show All Comments in the Comments section of the ribbon.  If the button is orange, it indicates that Excel is currently showing comments.  If it appears blue, Excel is not showing comments.  Click the Show All Comments button again to toggle between the two options.

Hide Comments and Comment Indicators

  1. Open Excel Options.
    1. Excel 2007 – Go to the Office button and click on Excel Options in the bottom right corner of the menu.
    2. Excel 2010 – Click on the File tab and in the left panel, click Options.
  2. Click on Advanced in the left column.
  3. Scroll down to the Display section.
  4. Select No comments or indicators.
  5. Click OK.

Here’s the catch – Don’t send a file out assuming that people cannot find your comments.  If anyone goes to the Review tab of the ribbon and clicks on Show All Comments, the comments and comment indicators will appear.  Clicking Show All Comments again will hide the comments, but not the comment indicators.  To hide the comment indicators again, you would need to go back to the Excel Options.