Thursday, June 2, 2011

Excel: Inserting Comments

Inserting comments into an Excel spreadsheet is simple, and you may be missing this opportunity to share information with your reader about the contents of a particular cell or group of cells.

For instance, if you have a budget spreadsheet and would like your reader to know that April's expenses are abnormal because you had to purchase a new copy machine, you could add a comment to that April expense by positioning your cursor in that cell and choosing:

  1. Insert
  2. Comment
  3. (Type your message, i.e. "$9,000 copy machine)
Then save your spreadsheet and your reader will be able to see, when he clicks in that spot, that there's a reason you are over budget in April!  (To view all comments at once, select View, Comments). 

No comments:

Post a Comment