Share & coauthor

Annotate a worksheet by using comments

Annotate a worksheet by using comments

Add comments to cells to explain what the cells contain.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Add a comment

  1. Right-click a cell and click Insert Comment.

  2. In the comment box, type your comment.

  3. Click outside the comment box.

    The comment box disappears, but a red comment indicator remains. To see the comment, hover over the cell.

    Tip: To format your comment, highlight the text you want to change, right-click on the comment and choose Format Comment.

Review comments

  • Select the Review tab, and click Next or Previous to see each comment in sequence.

See all comments at once

  • Select Review > Show All Comments to show or hide comments.

    You may need to move or resize overlapping comments.

    Note: Select Review > Show/Hide Comment to show or hide individual comments.

Move a comment

  • Drag the border of the comment box.

Resize a comment

  • Drag one of the handles on the sides or corners of the comment box.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×