totn Excel 2011 Basics

MS Excel 2011 for Mac: Display comment indicator next to cells with comments

This Excel tutorial explains how to display the comment indicator next to cells with comments in Excel 2011 for Mac (with screenshots and step-by-step instructions).

Question: When a comment has been inserted in a cell, the little red triangle is not being displayed to indicate a comment in a cell. What can I do to remedy this in Microsoft Excel 2011 for Mac?

Answer: As you can see, the little red triangle is not being displayed in cell A1 even though there is a comment in that cell.

Microsoft Excel

At the top left of the screen, select the Excel from the menu (to the right of the Apple) and then click on Preferences from the menu.

Microsoft Excel

When the Excel Preferences window appears, click on the View option under Authoring.

Microsoft Excel

When the View window appears,select the option called "Indicators only, and comments on hover". Then click on the OK button.

Microsoft Excel

Now when you return to the Excel spreadsheet, you should see the comment indicator. The comment indicator is the red triangle positioned in the top right corner of the cells that contain comments.

Microsoft Excel

If you hover over the cell, the comment will appear.