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
- Select the cell you wish to add a comment to, any single cell can contain a comment.
- Click Insert and select Comment or right-click the cell and select Insert Comment.
- Type in the comment.
- To close the comment, either click somewhere else in the spreadsheet or press ESC twice.
Viewing a comment
You can identify what 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
- Move to the cell containing the comment you wish to edit.
- 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 clicking them.
Deleting a comment
- Move to the cell containing the comment you wish to delete.
- 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.