Add, edit, or delete a comment

In Microsoft Office Excel, you can add a note to a cell by inserting a comment. You can edit the text in comments and delete comments that you no longer need.

What do you want to do?

Add a comment

Edit a comment

Delete a comment

Add a comment

1. Click the cell that you want to add a comment to.
2. On the Review tab, in the Comments group, click New Comment.

   

3. In the comment text box, type the comment text.

   Note In a comment, Excel automatically displays the name that appears in the Name box under Global Office Settings on the Personalize category of the Excel Options dialog box (Microsoft Office Button , Excel Options button). If needed, you can edit the name in the Name box. If you don't want to use a name, select it in the comment, and then press DELETE.

4. To format the text, select it, and then use the formatting options on the Home tab in the Font group.

   

   Note The Fill Color and Font Color options in the Font group are not available for comment text. To change the color of the text, right-click the comment, and then click Format Comment.

5. When you finish typing and formatting the text, click outside of the comment box.

   Tip A small red triangle in the corner of the cell indicates that the cell has a comment attached to it. When you rest the pointer over the red triangle, the comment is displayed.

Notes:

• To keep a comment visible with the cell, you can select the cell that contains the comment and then click Show/Hide Comment in the Comments group on the Review tab. To display all comments with their cells on the worksheet, click Show All Comments.
• When you sort, comments are sorted along with the data. In PivotTable reports, however, comments do not move with the cell when you change the layout of the report.

Edit a comment

1. Click the cell that contains the comment that you want to edit.
2. Do one of the following:
   • On the Review tab, in the Comments group, click Edit Comment.

     Note Edit Comment is available in the Comments group instead of New Comment when a cell that contains a comment is selected.

   • On the Review tab, in the Comments group, click Show/Hide Comment to display the comment, and then double-click the text in the comment.

   • 

3. In the comment text box, edit the comment text.
4. To format the text, select it, and then use the formatting options on the Home tab in the Font group.

   

   Note The Fill Color and Font Color options in the Font group are not available for comment text. To change the color of the text, right-click the comment, and then click Format Comment.

Delete a comment

1. Click the cell that contains the comment that you want to delete.
2. Do one of the following:
   • On the Review tab, in the Comments group, click Delete.
   • On the Review tab, in the Comments group, click Show/Hide Comment to display the comment, double-click the comment text box, and then press DELETE.

   • 

See also:

• Print comments