Quick Links

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.

01_adding_comment_to_formula

When you select the cell, the comment shows as part of the formula in the Formula bar.

02_formula_not_on_cell

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.

=RANDBETWEEN(1, 49)

This function will generate a random number between 1 and 49.

03_entering_random_function

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.

04_clicking_calculate_now

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.

05_clicking_review_tab

In the Comments section of the Review tab, click New Comment.

06_clicking_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.

07_editing_comment

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.

08_red_triangle_in_cell

When you move your mouse over the cell, the comment box displays.

09_comment_displays

To remove a comment from a cell, right-click on the cell and select Delete Comment from the popup menu.

10_selecting_delete_comment

Comments are a convenient way of documenting your spreadsheet both for your own reference and as “context-sensitive help” for users of your spreadsheet.