Comments in Excel come in handy for documenting your spreadsheet so you can remember what all the formulas are for or to provide instructions for other spreadsheet users. The How-To Geek points out a special function you can use to add a comment directly in the formula cell.
This is the N() function. To use it, just add a plus sign after your formula and whatever you want as your comment in quotes within the function, as in the screenshot above. Then, whenever you click on that cell, you'll see both the formula and your comment on it. The function works in Excel 2013 and earlier versions.
Excel users probably already know the other way to add a comment to a cell—through the "Insert a Comment" command. That creates a sticky-note-like comment that pops up when you mouse over the cell.
The N() function above is better if you don't want those comments and red triangles cluttering your spreadsheet and you're adding comments for your personal use.
Additionally, the comments show up when you search Excel, so you could use the N() function to "tag" cells with formulas for easy reference later (e.g., "Q2 budget" or "estimate").
Add Comments to Formulas and Cells in Excel 2013 | How-To Geek
via Lifehacker http://lifehacker.com/add-comments-to-a-formula-in-excel-for-your-future-refe-510113024
No comments:
Post a Comment