Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

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.

About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: