Pin Me

Cell Comments in Excel 2007

written by: •edited by: Tricia Goss•updated: 1/29/2009

In this tutorial, we’ll show how to add, view, and remove cell comments in an Excel 2007 worksheet.

  • slide 1 of 1

    Organize Spreadsheets with Cell Comments

    The comment feature in Excel 2007 allows you to create notes for any cell in a spreadsheet without detracting from the presentation of information. Not only is this useful for times when you are sharing a workbook with other people, but including comments is a great way to keep track of the modifications that you’ve made to spreadsheet cells in private workbooks.

    How to Add Comments to Cells

    There are two different ways to add a comment to a cell in Excel 2007. The quickest way is to right-click on the cell, and select the Insert Comment option.

    Insert a Comment - Method 1 

    Alternatively, you can open the Review tab on the Excel ribbon, and click the New Comment button.

    Insert a Comment - Method 2 

    Both of these methods will bring up a comment box in which you can type your note.

    Sample Comment Box 

    When you have finished typing the comment, you can click anywhere else on the spreadsheet to close the comment box. A small red triangle will appear in the upper right-hand corner of the cell denoting that there is a comment attached to it.

    Red Triangle Marking Comment 

    How to View and Edit Comments

    The simplest way to view a comment in Excel is to hover your mouse pointer over the red triangle representing the comment. This method is fine if you just want to take a quick glance at the note. However, any movement of the mouse away from the red triangle will cause the comment box to close again. This can be frustrating if the comment is long or if you want the box to remain open while you’re typing in other areas of the document.

    If you want better control over comment viewing, you can use the options found on the Review tab. Select the cell containing the comment you want to view and click Show/Hide Comment. Or, if you want to view all of the comments on the spreadsheet, click Show All Comments.

    Viewing Comments 

    To edit a comment, click anywhere in the comment box and begin typing. When you have finished viewing and/or editing the comments, click the same command again to hide the comments.

    How to Remove a Comment

    Similar to the process of adding a comment, there are two ways to remove one. The first way is to right-click on the cell containing the comment and select Delete Comment.

    Delete Comment - Method 1 

    Secondly, you can click on the cell containing the comment you want to remove, and then select Delete from the Comments section of the Review tab.

    Delete Comment - Method 2 

    For more tips and tricks, be sure to browse through the other Microsoft Excel tutorials available on the Bright Hub Windows Channel. Find out how to publish an Excel workbook as a web page, experiment with new chart and table design tips, learn to use conditional formatting to simplify data analysis, and more. New tutorials are being added on a regular basis so keep checking back.

Popular Pages

More Info