{"id":1151,"date":"2012-11-08T14:58:07","date_gmt":"2012-11-08T14:58:07","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1151"},"modified":"2023-12-30T23:11:50","modified_gmt":"2023-12-30T23:11:50","slug":"adding-comments-to-excel-worksheets","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/adding-comments-to-excel-worksheets\/","title":{"rendered":"Adding comments to Excel worksheets"},"content":{"rendered":"

Adding comments to an Excel spreadsheet<\/strong> helps when you are sharing a worksheet with colleagues. \u00a0You can add extra information to a figure in a cell, use to note trends, or add an action note.<\/p>\n

The comments are hidden when you are working in your normal worksheet view, but you know a comment has been added by the little red triangle in the top right of the cell, If you put your cursor over the cell, the message appears as a yellow post-it style note.<\/p>\n

To add a comment to a worksheet
\n<\/strong>Click on the cell you want to add a comment to. \u00a0Then go to the Review tab, and the Comments group.<\/p>\n

\"Comments-review-tab-training-courses-excel\"<\/a>
The comments box appears, I can add my comment press return and it’s saved. The red triangle in the top right corner reminds me that there is a comment.<\/figcaption><\/figure>\n

I can edit a comment or add to one made by another colleague, by selecting the comment, and using the Edit comment button.<\/p>\n

Viewing comments<\/strong>
\nIn a large worksheet, you may want to review all the comments quickly. \u00a0Excel can take you through each one in turn if you select Review tab, then in the Comments group, select Next. \u00a0Excel saves you scrolling through lots of data to find notes, by whizzing you through the document and locating the notes you need.<\/p>\n

Printing comments in a worksheet<\/strong>
\nIt can help when reviewing an Excel worksheet in a meeting, if you can have a print out of the sheet with the notes at the bottom of the sheet, or where they appear on screen. If you hit Print, the comments don’t appear.<\/p>\n

Go to the Page Layout tab and select the Page Set Up, and select the down arrow next to Comments. \u00a0This is where you can select the option that fits your needs. \u00a0Now when you print your document, you have access to the comments.<\/p>\n

\"Page-set-up-print-comments-training-courses-in-excel\"<\/a>
You can set up how you want the comments to appear in your hard copy.<\/figcaption><\/figure>\n

With comments, you have the flexibility to add extra details to your Excel worksheet, without it taking up lots of space. \u00a0It is easier to share comments with colleagues and get more out of your data. \u00a0Consider training-courses-in-excel for more Excel skills\u00a0https:\/\/www.stl-training.co.uk\/excel-2010-intermediate.php<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Adding comments to an Excel spreadsheet helps when you are sharing a worksheet with colleagues. \u00a0You can add extra information to a figure in a cell, use to note trends, or add an action note. The comments are hidden when you are working in your normal worksheet view, but you know a comment has been […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[37,545],"class_list":["post-1151","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-adding-comments-to-excel-worksheet","tag-training-courses-in-excel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1151"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1151\/revisions"}],"predecessor-version":[{"id":6713,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1151\/revisions\/6713"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}