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.

Logo for The 50 Best Tips

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!”

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Speak Your Mind

*