Using Excel 2010's Cell Comment Feature

You can add a cell comment — an electronic version of a sticky note — to any cell in an Excel 2010 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.

Add a comment to a cell

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

  1. Select the cell that needs a comment.

  2. On the Review tab, in the Comments group, click the New Comment button.

    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.

  3. Type your comment.

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

    Excel 2010 indicates commented cells with a red triangle.
    Excel 2010 indicates commented cells with a red triangle.
  4. Click outside the comment box.

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

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. On the Review tab, in the Comments group, click the Edit Comment button.

    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 click the Delete button in the Comments group on the Review tab.

blog comments powered by Disqus
Advertisement

Inside Dummies.com