How to Add/Update or delete a comment to a cell in Excel

Excel allow users to make comments for any cells in the spreadsheet. By default, those comments are visual only when the cell have been hovered by the mouse. Other time, Excel simply place a red triangle on the top-right corner to indicate there is a comment for the cell.

Comment
Comment

ADD COMMENT

Following is the steps to add a comment in Excel.

  1. Go to the cell that want to insert a comment
  2. Right click (alternative click) the cell, then the alternative menu will be displayed
  3. Click “Insert Comment”
    Insert Comment
  4. Enter the comment.
    Enter comment
  5. You can change the size of the comment by moving any one of those rectangle on the side of the comment
  6. Click anywhere outside the comment after entered the comment.Leave comment

The comment has been added to the cell.

EDIT COMMENT

Following is the steps to edit a comment in Excel.

  1. Go to the cell where the comment is marked
  2. Right click (alternative click) the cell, then the alternative menu will be displayed
  3. Click “Edit Comment”Edit Comment
  4. Edit the comment.Enter comment
  5. You can change the size of the comment by moving any one of those rectangle on the side of the comment
  6. Click anywhere outside the comment after entered the comment.
    Leave comment

DELETE COMMENT

Following is the steps to edit a comment in Excel.

  1. Go to the cell where the comment is marked
  2. Right click (alternative click) the cell, then the alternative menu will be displayed
  3. Click “Delete Comment”Delete Comment
  4. The comment will be deleted.

ALWAYS SHOW COMMENT

As mentioned, by default, the comment will be shown only when the cell was being hovered. However, there is also an option to always show the comment.

Following is the steps

  1. Go to the cell where the comment is marked
  2. Right click (alternative click) the cell, then the alternative menu will be displayed
  3. Click “Show/Hide Comment”Show/hide comment

Now the comment will always to shown.

Always show comment

Leave a Comment