How to Add a Comment to a Cell using Excel

How to Add a Comment to a Cell using Excel

Excel LogoA 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:

Random Values Spreadsheet in Excel 2007

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:

=RANDBETWEEN(1, 49)

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:

The Calculation Panel in Excel 2007

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

The Comments Panel in Excel 2007

A greenish textbox will appear to the right of cell B1, as in the image below:

A Comments Box

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.

Type your Comment

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:

The red triangle indicates that the cell contains a comment

If you move your mouse pointer over cell B1 the comment will appear:

Hold your mouse over the cell to see the comment

To get rid of a comment, right click the cell that contains the comment. Then, from the menu that appears, select Delete Comment.

Credit: http://www.homeandlearn.co.uk/excel2007/excel2007s2p10.html

One thought on “How to Add a Comment to a Cell using Excel

Leave a Reply

Your email address will not be published. Required fields are marked *