How to Add a Comment to a Cell using Excel
A comment can be added to any cell on your spreadsheet. When you hover your mouse pointer over a cell that contains a comment, you’ll see the comment appear in a sort of Sticky-Note. To see how they work, study the spreadsheet below:
The formula in cell B1 above gives you a random number from 1 to 49. A new number can be had by clicking the “Calculate Now” button on the Formula menu.
To let users know what to do, we’ll add a comment to cell B1.
First, create the spreadsheet above. In cell B2, enter the following formula:
The formula will generate a Random number between 1 and 49. Once you have the above spreadsheet up and running, click inside B1 and try it out:
- From the menu bars on the Ribbon at the top of Excel, click on Formula
- Locate the Calculation panel, and then click on Calculate Now:
Excel 2007 will refresh the calculation and enter a new random number for you. To let people know about this, you can add your comment to the cell. To add a comment to cell B1, do the following:
- Click inside cell B1 on your spreadsheet
- From the tabs on the Ribbon at the top of Excel, click on Review
- Click on New Comment
A greenish textbox will appear to the right of cell B1, as in the image below:
The word “user” in the image above is placed there by Excel. This is the name of the user account that was set up in Windows. Press the backspace on your keyboard to delete this.
To add your comment, just start typing. The size of the comment area can be increased or decreased by moving your mouse over the white circles. Hold down the left mouse button and drag.
When you have finished typing your comment, click on any other cell. The comment will disappear. Notice that the cell now has a red triangle in the top right. This indicates that it contains a comment:
If you move your mouse pointer over cell B1 the comment will appear:
To get rid of a comment, right click the cell that contains the comment. Then, from the menu that appears, select Delete Comment.