How to Annotate Excel Worksheets with Comments and Images
Do you use “post-it” sticky notes to remind you how to do something? Do you ever lose your reminder notes? I know that I do! So that is why I like to annotate my Excel Worksheets with Comments – this way I have the notes properly located (in the worksheet) when I need them (to remember how to write a particular formula, etc.) the most!
In this lesson, I also show you how to add “pictures” inside your comments. This is a great tip for adding in a picture for a catalog or order form.
A question that I am frequently asked: “How do I print out my comments?” Watch this video to find out how to do this – there are a couple of “got’cha” steps involved.
The 50 Best Tips
Here are three ways to enter a new comment that is attached to a single cell:
- Use the Keyboard Shortcut Shift + F2
- Right-Mouse Click and choose “Insert Comment”
- On the Review Tab of the Ribbon (Excel 2007) select the “Insert New Comment” command.
You can edit your comments, re size the shape of your comments, hide your comments (only a “red triangle” shows in the cell until you hover near the cell), show your comments (individually or collectively), delete, clear and paste your comments. I cover each of these techniques in this video lesson. And more!
Watch this video in High Definition, Full Screen Mode on my YouTube Channel – DannyRocksExcels
Learn how to “Master Excel in Minutes – Not Months!”
How to Annotate Excel Worksheets with Comments and Images [ 8:20 ] Play Now | Play in Popup | Download (193)
