When entering formulas in Excel, you may want to remind yourself, or someone else, what it was for in the future. Or you may want to add instructions to let users of your spreadsheet know what to do in certain cells.
We will show you how to add a comment to a formula and a comment that displays when you move your mouse over a cell.
Add a Comment to a Formula
The N() function allows you add comments directly inside your cells on your formulas. To use the function to add a comment, simply add a plus sign (+) to the end of your formula, and then enter some text in quotes inside the parentheses, passing that text to the N() function.
When you select the cell, the comment shows as part of the formula in the Formula bar.
Add a Comment to a Cell
You can also add a comment to a cell that displays when you move your mouse over that cell. This is helpful if you want to provide help for the users of your spreadsheet, informing them of how to use specific parts of your spreadsheet.
We will use the function that generates a random number between a range of numbers as an example. Enter the following formula in a cell in your spreadsheet.
This function will generate a random number between 1 and 49.
If you don’t have automatic calculation on, you have to click Calculate Now in the Calculation section of the Formula tab (or press F9) to generate a new random number.
To add a comment to the cell that lists the steps for generating a new random number, select the cell and click the Review tab.
In the Comments section of the Review tab, click New Comment.
A sticky note-style box displays pointing at the selected cell. By default, the user name of the current user is entered into the comment box, but you can delete this text or change it to something else. Enter any additional desired text into the comment box. You can resize the comment box using the small, outlined box handles along the edge.
Once you have entered your text, click on any other cell outside of the comment box. The cell now contains a small, red triangle in the upper, right corner, indicating a comment has been added to it.
When you move your mouse over the cell, the comment box displays.
To remove a comment from a cell, right-click on the cell and select Delete Comment from the popup menu.
Comments are a convenient way of documenting your spreadsheet both for your own reference and as “context-sensitive help” for users of your spreadsheet.
- Published 05/8/13