Adding a comment to a cell in Excel 2007

You can add text comments to particular cells in an Excel worksheet. Comments act kind of like electronic pop-up versions of sticky notes.

For example, you can add a comment to yourself to verify a particular figure before printing the worksheet or to remind yourself that a particular value is only an estimate (or even to remind yourself that it's your anniversary and to pick up a little something special for your spouse on the way home!).

In addition to using notes to remind yourself of something you've done or that still remains to be done, you can also use a comment to mark your current place in a large worksheet. You can then use the comment's location to quickly find your starting place the next time you work with that worksheet.

Adding a comment to a cell

To add a comment to a cell, follow these steps:

1) Move the cell cursor to or click the cell to which you want to add the comment.

2) Click the New Comment command button on the Ribbon’s Review tab or press Alt+RC.

A new text box appears. This text box contains the name of the user as it appears in the User name text box on the Personalize tab of the Excel Options dialog box (Alt+FIP) and the insertion point located at the beginning of a new line right below the user name.

3) Type the text of your comment in the text box that appears.

4) When you finish entering the comment text, click somewhere on the
worksheet outside of the text box.

Excel marks the location of a comment in a cell by adding a tiny triangle in the upper-right corner of the cell. (This triangular note indicator appears in red on a color monitor.)

5) To display the comment in a cell, position the thick white-cross mouse pointer somewhere in the cell with the note indicator.

Tags: sticky notes,worksheet

Related Articles