Track Changes and Comments

In Excel track changes is a useful feature. Track changes in Excel and use the comments feature when proofreading workbooks.

Comments

Sometimes you may want to add a comment to provide feedback instead of editing the contents of a cell. While often used in combination with Track Changes, you don't necessarily need to have Track Changes turned on to use comments.

To add a comment:

  1. Select the cell where you want the comment to appear. In our example, we'll select cell D17.
    Selecting cell E8
  2. From the Review tab, click the New Comment command.
    Clicking the New Comment command
  3. A comment box will appear. Type your comment, then click anywhere outside the box to close the comment.
    Adding a comment
  4. The comment will be added to the cell, represented by the red triangle in the top-right corner.
    Comment indicator
  5. Select the cell again to view the comment.
    Selecting a cell to view a comment

To edit a comment:

  1. Select the cell containing the comment you want to edit.
  2. From the Review tab, click the Edit Comment command.
    Clicking the Edit Comment command
  3. The comment box will appear. Edit the comment as desired, then click anywhere outside the box to close the comment.
    Editing a comment

To show or hide comments:

  1. From the Review tab, click the Show All Comments command to view every comment in your worksheet at the same time.
    Clicking the Show All Comments command
  2. All comments in the worksheet will appear. Click the Show All Comments command again to hide them.
    Viewing all comments at the same time

You can also choose to show and hide individual comments by selecting the desired cell and clicking the Show/Hide Comment command.

Showing and hiding individual comments

To delete a comment:

  1. Select the cell containing the comment you want to delete. In our example, we'll select cell E13.
    Selecting cell E8
  2. From the Review tab, click the Delete command in the Comments group.
    Clicking the Delete command
  3. The comment will be deleted.
    After deleting the comment