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 E8.
    Screenshot of Excel 2013Selecting cell E8
  2. From the Review tab, click the New Comment command.
    Screenshot of Excel 2013Clicking the New Comment command
  3. A comment box will appear. Type your comment, then click anywhere outside the box to close the comment.
    Screenshot of Excel 2013Adding a comment
  4. The comment will be added to the cell, represented by the red triangle in the top-right corner.
    Screenshot of Excel 2013The added comment
  5. Select the cell again to view the comment.
    Screenshot of Excel 2013Selecting 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.
    Screenshot of Excel 2013Clicking 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.
    Screenshot of Excel 2013Editing 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.
    Screenshot of Excel 2013Clicking the Show All Comments command
  2. All comments in the worksheet will appear. Click the Show All Comments command again to hide them.
    Screenshot of Excel 2013Viewing all comments at the same time

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

Screenshot of Excel 2013Showing 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 E8.
    Screenshot of Excel 2013Selecting cell E8
  2. From the Review tab, click the Delete command in the Comments group.


    Screenshot of Excel 2013Clicking the Delete command
  3. The comment will be deleted.
    Screenshot of Excel 2013After deleting the comment