Using Excel 2007’s Cell Comment Feature

You can add a cell comment — an electronic version of a sticky note — to any cell in an Excel 2007 worksheet. Comments allow those reviewing a worksheet to provide instruction, for example, noting how a complex formula works, entering thoughts, questions, and even specifics about the type of information that the end user should enter into the cells. Adding a comment does not change the overall appearance of the worksheet.

Add a comment to a cell

Follow these steps to add a comment to a cell in an Excel 2007 worksheet:

  1. Click the New Comment button in the Comments group of the Review tab.

    A yellow comment box with your name and a blinking cursor appears. With the comment box open, you can drag the lower-right corner of the comment box to make it larger.

  2. Type your comment.

    Comments can be up to 32,767 characters in length.

  3. Click outside the comment box.

    Excel accepts the comment and displays a red triangle in the upper-right corner of the commented cell.

    Excel 2007 indicates commented cells with a red triangle.
    Excel 2007 indicates commented cells with a red triangle.

Point to a cell containing a red triangle to display the comment text.

Edit a cell comment

To edit an existing cell comment, follow these steps:

  1. Select the cell with the comment you want to edit.

  2. Click the Edit Comment button in the Comments group of the Review tab.

    The yellow comment box displays.

  3. Make any desired changes to the comment, and then click outside the comment box.

    You can edit cell comments as necessary.
    You can edit cell comments as necessary.

View multiple cell comments

Use the following steps to view multiple cell comments in a worksheet:

  1. Click a cell with a comment and pause your mouse over the comment indicator.

    Excel displays the comment text; but as you move your mouse away from the comment indicator, the comment text hides.

  2. Try the following options:

    • Click the Next button or the Previous button in the Comments group of the Review tab. Excel displays another comment.

    • Click the Show/Hide Comment button in the Comments group of the Review tab. Excel keeps the current comment displayed on the screen until you click this button again.

    • Click the Show All Comments button in the Comments group of the Review tab. Excel displays all comment boxes on the current worksheet. Click the Show All Comments button again to turn off the comment display.

      Use the Show All Comments button to view multiple comments on screen at one time.
      Use the Show All Comments button to view multiple comments on screen at one time.

To delete a comment, select the cell with the comment and choose the Delete button in the Comments group on the Review tab.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com