Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Before I share this spreadsheet, I'd like to add some comments in certain areas, were I would like someone to review the information in detail. And I'm going to do that by using the New Comment option in the Comments group, on the Review tab. Let's say I would like to identify that the cost of this particular pastry flour is quite high. It's costing us $7.00, for that particular pastry flour. So I want to send this item over to one of my suppliers and just see if there's any way that I can get this at a reduced cost.
I select the cell where I want to put the comment in, and a go up to the New Comment command in my Comments group. Clicking it once allows me to type in the information in a dialog box you see here. It identifies the person writing the comment so that we can track what comments were made by whom. In this particular case, I want to make a note of Can I get this flour at a better price? Clicking off of the comment area removes it from view and editing, but as I mouse over the indicator, the little red arrow in the top corner of the cell where I made the comment, I can then see the comment pop-up for my review.
If I'd like to edit this comment, I can go back up to the Edit Comment box in my Comments group, select it, and it'll allow me to add in additional information in that particular comment. If I'm happy with it, I just click off the comment and I now have my different comment options available to me. I can review the comments that are in a particular spreadsheet by using the Previous, Next buttons commands that I see here. If I'd like to see the next comment in the spreadsheet, I simply click on the Next command button and it pops me down to the next comment in the column that I'm working in.
If I'd like to go back to the previous comment, I simply click the Previous button and it pops me up. If I'd like to delete a particular comment, I can do so by clicking on the Delete comment button here. At any point in time, I can show all the comments in a particular document by selecting the Show All Comments command. So I can see everything in front of me. As well, once I've reviewed all of the comments, I can hide them by clicking the Show/Hide Comments.
And in this case, I can hide that one as well. By using the commenting ability in the Excel spreadsheets, you can really identify to people, your thoughts on different areas of the spreadsheet, that you can then share with them as you send off the information in your spreadsheet.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 98120 Viewers
80 Video lessons · 141333 Viewers
59 Video lessons · 59685 Viewers
52 Video lessons · 72914 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.