How to Add a Note to an Excel Formula

You can add a note to an Excel formula. Two methods exist. One way is to use the "Comment" function. Another way is to append the "N" function to an existing formula.

Instructions

1. Open an Excel file with existing formulas or create your worksheet with at least one formula.

2. Click in the cell at the end of the formula. For example, click within cell A5. Then type the formula "=A2+A3" (without quotes).

3. Go to the "Ribbon" at the top of Excel and click on "Review." Click on "New Comment." A colored text box will appear to the right of cell A5.

4. Start typing your comment after the username that appears. When finished typing, click another cell. The cell with a comment will contain a red triangle. Move your mouse over the cell to reveal the comment.

5. Alternatively, add a note directly to the Excel formula by using the "N" function. To do so, add the following to your existing formula: +N(“Write your comment here”). Move your mouse over the cell to reveal the comment.

References

• Home & Learn: Microsoft Excel 2007 to 2010: Add a Comment to a Cell
• TechRepublic: An Unconventional Way to Comment Your Excel Formulas