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 (627)