{"id":628,"date":"2017-08-02T15:13:11","date_gmt":"2017-08-02T07:13:11","guid":{"rendered":"http:\/\/owa.sodexo-cn.com\/blog\/?p=628"},"modified":"2017-08-02T15:17:13","modified_gmt":"2017-08-02T07:17:13","slug":"add-comments-in-excel","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=628","title":{"rendered":"Add comments in Excel"},"content":{"rendered":"<p>When many staffs make Excel spreadsheets, they often do not know how to fill in the reserved cells, we can add the comments to the cell description, so that we can understand the purpose of each cell. Take the following &#8220;Employee Computer use checklist&#8221; table as an example.<\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>Select the cell B1, switch to the Review tab, click the New comment button.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-629\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/08\/011a.jpg\" alt=\"\" width=\"928\" height=\"614\" \/><\/li>\n<li>Enter the description in the comment text edit box.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-630\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/08\/022b.jpg\" alt=\"\" width=\"768\" height=\"614\" \/><\/li>\n<li>Place the cursor at the edge of the comment box, and the cursor will turn into a double-headed arrow, clicking and dragging to the appropriate location to release the mouse. Use the same method to add comment to other headers and scale.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-631\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/08\/033c.jpg\" alt=\"\" width=\"768\" height=\"614\" \/><\/li>\n<li>Select the Excel cell D1 edit the comment box, the previous B1 comment bar may be disturbed, and you can select the Show\/Hide comment button.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-632\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/08\/044d.jpg\" alt=\"\" width=\"768\" height=\"614\" \/><\/li>\n<li>Then add edit D1 E1 F1 G1 cell comment, click the Show\/Hide comment button each time you edit, and hide the comment to avoid blocking the next generated comment.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-633\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/08\/055e.jpg\" alt=\"\" width=\"928\" height=\"614\" \/><\/li>\n<li>When you click the Show all comments button, all comments are displayed.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-634\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/08\/066f.jpg\" alt=\"\" width=\"1071\" height=\"614\" \/><\/li>\n<li>Position the cursor over the edge of the comment box, and the cursor becomes a two-way cross arrow, and clicking and dragging to the appropriate location.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-635\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/08\/077g.jpg\" alt=\"\" width=\"1071\" height=\"614\" \/><\/li>\n<li>Click the Delete button to delete the comments.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-639\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/08\/088h2.jpg\" alt=\"\" width=\"768\" height=\"614\" \/><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>When many staffs make Excel spreadsheets, they often do &#8230; <a title=\"Add comments in Excel\" class=\"read-more\" href=\"https:\/\/owa.sodexo-cn.com\/blog\/?p=628\" aria-label=\"\u9605\u8bfb Add comments in Excel\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-628","post","type-post","status-publish","format-standard","hentry","category-tips"],"views":4144,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/628","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=628"}],"version-history":[{"count":3,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/628\/revisions"}],"predecessor-version":[{"id":640,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/628\/revisions\/640"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}