Add or remove a comment

Comments are notes that you attach to cells, separate from other cell content. You can enter one comment per cell. A cell that contains a comment displays an indicator triangle in the upper-right corner of the cell. When you rest the pointer over the cell that displays an indicator triangle, the text of the comment appears in a box near the cell.

Example of a comment in a cell

Comment in cell

When you sort data, comments are sorted along with the data. In PivotTable reports, however, comments do not move with the data when you change the layout of the report, but remain anchored to the cells where you entered them, not to the data in that cell.

Add a comment

  1. Click the cell where you want to add a comment.

  2. On the Review tab, click New Comment.

    Insert new comment

  3. In the box, type the comment text.

    To remove your name from the comment, select your name and delete it.

  4. When you have finished typing the text, click outside the comment box.

Delete a comment

  1. Select the cell that contains the comment you want to delete.

  2. CONTROL+click or right-click, and then click Delete Comment.

More options

  1. Click the cell that contains the comment you want to edit.

    Note: If you can't see comments, or comment indicators, on the Review tab, click Next to see each comment in the workbook, or click Show All Comments to see all comments at once.

  2. Click in the comment and make your changes.

  3. When you have finished, click outside the comment box.

  1. On the Edit menu, click Find > Go To.

  2. Click Special.

  3. Click Comments, and then click OK.

  4. On the Edit menu, point to Clear, and then click Comments.

If you don't want comments or comment indicators to be displayed on a sheet, you can hide them.

  • To hide comments but keep indicators visible, click Show All Comments on the Review tab.

  • To hide comments and their indicators, on the Excel menu, click Preferences > View, and under For cells with comments, show, select the option that you want.

  1. On the Review tab, click Next.

  2. Select your name on the comment and delete it.

  3. Continue clicking Next, removing your name from each comment until you reach the end of the workbook.

Add a comment

  1. Click the cell where you want to add a comment.

  2. On the Review tab, under Comments, click New.

    Excel Review tab, Comments group

  3. In the box, type the comment text.

    To remove your name from the comment, select your name and delete it.

  4. When you have finished typing the text, click outside the comment box.

Delete a comment

  1. Select the cell that contains the comment you want to delete.

  2. Hold down CONTROL, click the cell that contains the comment, and then on the contextual menu, click Delete Comment.

More options

  1. Click the cell that contains the comment you want to edit.

    Note: If you can't see comments, or comment indicators, on the Review tab, under Comment, click Next to see each comment in the workbook.

  2. Click in the comment and make your changes.

  3. When you have finished, click outside the comment box.

  1. Hold down CONTROL, click the cell that contains the comment, and then on the contextual menu, click Copy.

  2. Hold down CONTROL, click the cell where you want to paste the comment, and then on the contextual menu, click Paste Special.

  3. Click Comments.

  4. To cancel the moving border, press ESC .

    Note: A comment that is copied to a cell replaces any existing comment in the destination cell.

  1. On the Edit menu, click Go To.

  2. Click Special.

  3. Click Comments, and then click OK.

  4. On the Edit menu, point to Clear, and then click Comments.

If you don't want comments or comment indicators to be displayed on a sheet, you can hide them.

  1. On the Excel menu, click Preferences.

  2. Under Authoring, click View   Excel View Preferences button .

  3. Under For comments, show, select the option that you want.

  1. On the Review tab, under Comments, click Next.

    Excel Review tab, Comments group

  2. Select your name on the comment and delete it.

  3. Continue clicking Next, removing your name from each comment until you reach the end of the workbook.

See also

Print comments

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×