Comments

The Comments feature can be used to annotate worksheets and/or to provide input guidelines for the user.  If you are creating or editing several notes at a time, you may find it easiest to turn on the Reviewing toolbar. If you want to keep track of changes made to a workbook, refer to the Tracking Changes article.

Displaying The Review Ribbon

  1. Display the Review ribbon. Notice the choices available within the Comments area of the ribbon.

Insert A Comment

  1. Select the cell you wish to add a comment to.


  2. Click on the New Comment button in the Review ribbon.
  3. Or right mouse click in a cell and choose Insert Comment.

  4. In the popup box, type your comment then click anywhere outside of the box to finish.
  5. Your user name appears at the top of the comment. If this information is not correct, you can change this within your Excel Options.

Viewing Comments

Editing Comments

  1. Display all comments, as indicated under Viewing Comments, above.


  2. Click in the comment box you wish to change and make the appropriate changes.  Click anywhere outside the comment box to finish.
  3. Or right mouse click in a cell and choose Edit Comment.

  4. To change the size of a comment box, display all comments, as described above.  Click on the box once then drag a corner handle in or out.


  5. To move a comment box, display all comments, as described above.  Click on the comment box you wish to move.  Point at the border of the comment box (your cursor will display as a four-pointed arrow).  Drag the box to its new location.  The connecting line will adjust accordingly.

Deleting Comments

  1. Select in the cell to which the comment is attached.


  2. Click on the Delete Comment button in the Review ribbon.
  3. Or right mouse click in a cell and choose Delete Comment.

Printing Comments

You need to tell Excel to print comments with the worksheet.

  1. Display the Page Layout ribbon and click on the button at the right of Page Setup.


  2. Select the Sheet tab.


  3. Use the list button beside the Comments field to change the selection to either:
  1. Click on OK when done.

When you print the worksheet, the comments will also print.

Additional References