Join Dennis Taylor for an in-depth discussion in this video Adding, managing, and printing comments for worksheet documentation, part of Excel Tips Weekly.
- You can provide valuable worksheet…documentation and inform others…as to what's going on on a worksheet…by inserting comments.…A comment is associated with a cell.…In this worksheet, you might have…noticed already, red triangles.…Those contain comments, notice I'm…just sliding over for example, cell D4,…the comment pops up,…"Includes one-time sales of warehouse items."…And slide over G4, there's another one there.…At different times we might want…to see all these, we might want to print them,…we might want to print them as we see them,…or we might want to print them on a separate sheet,…variety of techniques here for making…these more valuable than they might…at first appear.…
And we can also add them as we wish.…I want to add a comment in cell B5…to contrast this number with last year's information.…Now, if you're looking for the…actual option for inserting a comment,…you might go to the Insert tab,…but you won't find it there.…It might take you (mumble) to find it…in the menu system.…It's on the Review tab, New Comment.…
Skill Level Appropriate for all
Excel Tips - New This Week
- 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.