Microsoft Office Tips, Tricks, and How-to's to help you use MS Office like a pro!

Carol's Corner Office

Adding Comments to a Formula in Excel

Posted on by Posted in Microsoft Excel

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 handly little trick to add a comment to a formula in MS Excel:

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

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