Adding Comments to a Formula in MS Excel

Dennis Faas's picture

Sometimes you would just love to have a comment that would make things clearer for the person using the worksheet in MS Excel, wouldn't you?

Well you can use this handy little trick to add a comment to a formula in MS Excel:

  • At the end of your formula, add a plus sign (+), to the N function, and an open parentheses.
     
  • Key in your comment in quotation marks.
     
  • Close the parentheses.  

You can view the comment in the formula bar whenever you select the cell.

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

| Tags:
Rate this article: 
No votes yet