Some Excel Tips and Tricks for Using Comments.

Posted on March 5, 2008 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - Some Excel Tips and Tricks for Using Comments.

Today’s Tip and Trick is a pretty cool one for Microsoft Excel. Working in MS Excel can be a hard job especially when you are working with complicated formulas and lots of entries to fill in. If you are working in a complex spreadsheet it might be helpful to write some things down.  Instead of using pen a paper you can make comments in your spreadsheet. This way you can comment in the excel cells that you’ll need to edit instead of writing up the location.

 

The Excel Tips and Tricks for using comments.

 

First the basics; how too create a comment. 

 

If you are standing with the cursor in a cell you can right click and Insert Comment and you can enter your text.

 

And other way is to stand in a cell and open the menu Review and click on New Comment. You can also see some extra options that you can use for the comments. This is the way for Microsoft Outlook 2007; the previous versions work pretty much the same.

 

But these two ways are in fact unnecessary because you can also stand in a cell with your cursor and press SHIFT+F2.  But you need to know the basic’s don’t you agree;)?

 

Excel-tips-tricks-pic1

 

The last Trick for now is that you can move the displayed comment to another place if you don’t like where it is positioned now. Normally the comments look like the picture above here.

 

Okay let’s move the Excel comment.

 

  • First stand in a cell with your cursor.
  • Press SHIFT+F2 and don’t touch your mouse or any key!!
  • Now press the Escape button and hold it down.
  • You can now use the arrows to move the comment to any place you like. 

 

Excel-tips-tricks-pic2

 

Don’t you like it much better here? Now you can see what’s under your comment.

 

And that’s today’s Excel Tip and Trick, I hope you all liked it and ill see you all tomorrow!!

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

3 Responses to “Some Excel Tips and Tricks for Using Comments.”

  1. Mabellakk on March 19th, 2008 7:22 am

    nice work, dude

  2. Stronghold on March 27th, 2008 5:44 pm

    Good thread, i like this tips :)

  3. Baskaran on August 4th, 2008 7:16 am

    Hai , Its very intresting , i love learn more about your site .

Leave a Reply