Sunday, December 25, 2011

How to Add a Note to an Excel Formula


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.

Blogger news