By annotating a worksheet with comments, you can attack additional information to a cell to describe the cell for convenient reading and understanding. For example:<\/p>\n
- \n
- Ask questions about the data with comments<\/li>\n
- Leave your feedback in excel document from another person<\/li>\n
- Describe certain value in cells of Excel<\/li>\n
- Explain formulas to other users<\/li>\n<\/ol>\n
<\/p>\n
- \n
- How to Add Comments to Cell in Excel<\/a><\/strong><\/li>\n
- How to Show or Hide Comments to Cells in Excel<\/a><\/strong><\/li>\n<\/ul>\n
\u00a0How to Add Comments to Cell in Excel<\/h2>\n
Text and picture are two different kinds of content in comment. The way to add them is also different. So now let\u2019s see how to create the two kinds of comments for cell in Excel (2010).<\/p>\n
Text comment:<\/h3>\n
Step 1: Select the cell that you want to add comment.<\/strong><\/p>\n
Step 2: Add comment to cell with three ways.<\/strong><\/p>\n
1.<\/strong> Go to the Review<\/strong> tab, and click on New Comment<\/strong>\u00a0icon in Comments<\/strong> group.<\/p>\n
2.<\/strong> Right click the cell and select Insert Comment<\/strong> option from the context menu.<\/p>\n
3.<\/strong> Press Shift + F2<\/strong> to easily add comment to cell.<\/p>\n
![\"add](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/add-comment-to-cell-in-excel.png\")
<\/a><\/p>\nNow you can edit the comment, including changing default user name<\/strong><\/a> and entering content in the comment textbox. Or later, you can select the comment and click Edit Comment<\/strong> button to begin to change the comment.<\/p>\n
![\"successfully](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/successfully-create-comment-to-cell.png\")
<\/a><\/p>\nPicture Comment:<\/h3>\n
While you need to insert a picture to comment, follow the steps to do.<\/p>\n
1.<\/strong> Right-click the comment and click Format Comment<\/strong>.<\/p>\n
![\"choose](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/choose-to-format-comment.png\")
<\/a><\/p>\n2.<\/strong> Click Colors and Lines<\/strong>\u00a0tab and in the drop-down list of Color<\/strong>, select Fill Effects<\/strong>.<\/p>\n
![\"choose](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/choose-fill-effects.png\")
<\/a><\/p>\n3.<\/strong> In pop-up Fill Effects<\/strong> dialog, tap on Picture<\/strong> and click Select Picture<\/strong> button to choose the picture you want to insert to comment.<\/p>\n
![\"choose](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/choose-picture-as-fill-effects.png\")
<\/a><\/p>\n4.<\/strong> Click the picture and Insert<\/strong> button in Select Picture<\/strong> window.<\/p>\n
![\"select](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/select-and-insert-picture-into-comment.png\")
<\/a><\/p>\n5.<\/strong> Click OK<\/strong> in Fill Effects<\/strong> dialog and Format Comment<\/strong> dialog. Then the picture you select is added as comment.<\/p>\n
![\"confirm](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/confirm-picture-as-fill-effects.png\")
<\/a><\/p>\n![\"confirm](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/confirm-inserted-picture-as-comments.png\")
<\/a><\/p>\nAfter comments is added to a cell in Excel, if you don\u2019t choose to show, you would not see the comment in Excel sheet, just could know which cell has a comment through the red mark in the right-top button of cell.<\/p>\n
![\"successfully](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/successfully-add-picture-comment-to-cell.png\")
<\/a><\/p>\nSo let\u2019s learn how to show and hide the comments in Excel as we like.<\/p>\n
<\/p>\n
How to Show\/Hide Comments to Cell in Excel<\/h2>\n
If there are lots of comments having been created in Excel, you have several choices to display one or all of the comments in Excel.<\/p>\n
Option 1: Show comments one by one in Excel (Previous, Next) <\/strong><\/p>\n
With Previous<\/strong> and Next<\/strong> button in Review<\/strong> tab and Comments<\/strong> session, you can view the comments one by one in the Excel.<\/p>\n
![\"show](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/show-comments-one-by-one-with-previous-and-next-button.png\")
<\/a><\/p>\nUntil all the comments are showed, it would give you a warning message about that you have seen all of the comments.<\/p>\n
![\"warning](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/warning-message-after-showing-all-comment.png\")
<\/a><\/p>\nOption 2: Show or Hide All Comments at once in Excel<\/strong><\/p>\n
If you decided to show all the comments instantly in Excel, Show Comments<\/strong> option in Excel tab would help you to do that easily.\u00a0Navigate to Show All Comment<\/strong> location in Excel, and click it. All comments would display for cells and you can see all of them.<\/p>\n
![\"show](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/show-or-hide-all-comments.png\")
<\/a><\/p>\nOption 3: Show or Hide Comment with command “Show\/Hide Comment”<\/strong><\/p>\n
1.<\/strong> Right-click the cell that has comment and select Show\/Hide Comments<\/strong> from context menu.<\/p>\n
![\"show](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/show-or-hide-comments-with-command.png\")
<\/a><\/p>\n2.<\/strong> Instantly all the comments in Excel are displayed and hidden.<\/p>\n
Surely, if you want to edit comment for cell, you can select the cell and click “Edit Comment<\/strong>“.\u00a0Or if you want to delete comment, just choose the cell has the comment, and click “Delete<\/strong>“.<\/p>\n
<\/p>\n
Related Articles:<\/strong><\/p>\n
- \n
- 3 Methods to Hide or Unhide One or Multiple Sheets in Excel 2016-2007<\/a><\/li>\n
- 2 Ways to Unprotect Excel Worksheet without Password<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
In the article, we would find the meanings of comments, and learn how to add and operate the…<\/p>\n","protected":false},"author":1,"featured_media":126187,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[230],"class_list":["post-4623","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-documents","tag-excel"],"_links":{"self":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4623","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/comments?post=4623"}],"version-history":[{"count":5,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4623\/revisions"}],"predecessor-version":[{"id":6455,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4623\/revisions\/6455"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/126187"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=4623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=4623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=4623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- 2 Ways to Unprotect Excel Worksheet without Password<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
- How to Show or Hide Comments to Cells in Excel<\/a><\/strong><\/li>\n<\/ul>\n
- How to Add Comments to Cell in Excel<\/a><\/strong><\/li>\n