Insert Comment in Excel | CustomGuide

Insert Comment in Excel

How to Add, Edit, and Delete Cell Comments in Excel

Insert Comment in Excel

Sometimes you may need to add notes to document complicated formulas, call out questionable values, or even to leave a comment for another user. Excel’s cell comments command helps you document your worksheets and make them easier to understand. Think of cell comments as sticky notes that you can attach to any cell. Cell comments appear whenever you point at the cell they’re attached to.

Add a Comment

  1. Click the cell where you want to add the comment.
  2. Click the Review tab.
  3. Click the New Comment button.
    Cell Comments

    Right-click a cell and select New Comment.

  4. Type the comment you want.
  5. Click the Post button.
  6. Click anywhere outside the comment.
    Cell Comments

The comment disappears, but a red triangle appears in the corner of the cell to show that it has a comment.

View a Comment

  1. Point to a cell with a comment icon.
    Cell Comments

To display a comment all the time, click the cell with the comment, then click the Review tab on the Ribbon and click the Show/Hide Comments button in the Comments group.

Edit a Comment

  1. Click the cell that contains the comment you want to edit.
  2. Click the Edit button in the comment.
    Cell Comments
  3. Make the changes and then click Save.
    Cell Comments

    Right-click a cell with a comment and select Edit Comment.

The comment box reappears, ready for editing.

Delete a Comment

  1. Click the cell that contains the comment you want to delete.
  2. Click the Review tab.
  3. Click the Delete button.
    Cell Comments

    Right-click a cell with a comment and select Delete Comment.

The comment is removed from the cell.