One very effective way to collaborate with other users is to add comments to a workbook. Adding comments lets you make notes without changing the contents of any cells. In this video, learn how to add, edit, display, and delete comments.
- [Tutor] One very effective way to collaborate with other users is to add comments to a workbook. Adding comments lets you make notes without changing the contents of any cells. In this movie, I will show you how to add, edit, display, and delete comments. My sample file is the Comments Workbook and you can find it in the Chapter 10 folder of the Exercise Files collection. In this workbook I have a set of projections for the number of units sold in four different categories, and I'd like annotate my numbers by adding some comments.
To do that I will select the cell where I want to add the comment and in this case I'll make it cell B3, and then go to the Review Tab of the ribbon, and then click the New Comment button. Doing so displays a comment box for the cell that I had selected, and it also has the name of the active user; in this case this is my MacOS account. So I'll say, "Good growth from last year", and then click away perhaps to cell B4, and you can see that there is an indicator at the top right corner of cell B3, the red triangle indicating that there is a comment.
If I hover the mouse pointer over cell B3, then the comment is displayed and when I move the mouse pointer away, it goes away. If I were to click cell B3 to select it, then the same thing happens. Whenever the mouse pointer is over the cell, the comment's displayed, if not, it doesn't. Now say I want to edit a comment; I'll edit the comment that I just created in B3. So with cell B3 selected I'll click the Edit Comment button which replaces the New Comment version when there is a comment already in the cell, and it's opened as a text box for editing.
So I'll just say instead of good, I'll say the growth was great, and click away. If you want to add another comment, you can add that in another cell. So I'll click cell B5 and then click New Comment, and I'll say, "How do we get this number to 7000?" - assuming the sales are somewhat disappointing - and now I'll click away to cell B6. So now I have two comments in my worksheet.
I can show or hide a specific comment by clicking the cell that contains the comment, and then on the Review Tab, clicking Show or Hide Comment; that leaves it up even if I click away to another cell. I can also turn it off by clicking the Show/Hide Comment button again, and if I want to show all comments in a worksheet which is helpful in case you've turned indicators off for some reason, click Show All Comments and there they are. And like other objects, you can resize and move comment boxes as required.
If you want to move among your comments, you can do that also using the Previous and Next buttons. So I'll click Show All Comments again to remove them and note that no cell in the worksheet is selected, and in fact I have one of the comments that is currently selected here as indicated in the Name Box, so I'll click in cell B3, and now I can move among the comments. So I have one comment here, if I click Next, then it displays it, "Great growth from last year." If I click Next again, then it displays the next comment and if I click Next one more time, I get an indication that there are no more comments in the workbook so I'll click Cancel.
If I want to go to the previous comment I can click Previous, and if I want to delete a comment entirely then I can select the cell that contains the comment, in this case B3, and click Delete. As you can see, comments are extremely useful. What I like to do when reviewing worksheets with comments in them is to display all of them using Show All Comments to see where they are, and then work through them one at a time using Next and Previous.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.