Reference number: CH000703

How can I create and edit a comment in Microsoft Excel?

Question:

How can I create and edit a comment in Microsoft Excel?

Answer:

Microsoft Excel has the ability of creating comments in each of the cells. Comments enable a user to get additional information about the cell such as what the value represents. Below is additional information about creating and editing a comment in Microsoft Excel.

Creating a comment

1. Select the cell you wish to add a comment to, any single cell can contain a comment. 
2. Click Insert and select Comment or right-click the cell and select Insert Comment.
3. Type in the comment.
4. To close the comment, either click somewhere else in the spreadsheet or press ESC twice.

Viewing a comment

You can quickly identify which cells have comments in them by looking for a red arrow head in the top right of the cell as seen below.

Once you've identified the cell you wish to view, move the mouse over the cell to view the comment.

If you wish to view all the comments, click View and then Comments. This will show all comments on the spreadsheet.

Hide comments

Comments will auto hide when moving the mouse off the comment unless following the above steps to view all comments. If you wish to hide all comments, click View and then Comments.

Modifying a comment

1. Move to the cell containing the comment you wish to edit.
2. Right-click the cell and click Edit comment. If you have multiple comments you wish to edit, click View and then Comments to view all the comments and edit the comments by simply clicking them.

Deleting a comment

1. Move to the cell containing the comment you wish to delete.
2. Right-click the cell and click Delete comment. If you have multiple comments you wish to delete, click View and then Comments to view all the comments and delete each of the comments by clicking on Delete comment within the Reviewing comment toolbar.