Editing Comments

You may find that you want to change a comment after you've created it. Use the Edit Comment feature in Excel to modify the text, layout, and size of comments in your worksheet.

To modify comments:

  1. Click the cell with the comment you want to change.
  2. Click the Edit Comment button on the Reviewing toolbar.
  3. Click inside the comment balloon and make your changes.
  4. Click and drag a resize handle to change the size of the balloon.
  5. Point to a balloon boundary and when the cursor becomes a move handle drag the balloon to change its position in the worksheet.


To delete a comment from a cell:

  • Click the Delete Comment button on the Reviewing toolbar.
  • Select Comments from the Clear submenu on the Edit menu.

To format a comment:

  • Right-click the comment and click Format Comment... on the menu.
  • Click the comment and select Comment... on the Format menu.
  1. Click the Show All Comments button on the Reviewing toolbar.
  2. Select the comment you want to change and make your changes.