Excel > Excel 2007 Foundation > Editing a worksheet

Cell Comments

Cell comments allow you to add notes to a worksheet for yourself and other users. They appear when you point to a cell containing a comment, and are recognised by a triangle in the corner of the cell.

Inserting a comment

  1. Select the cell
  2. Click the Review tab on the Ribbon, and then the New Comment button from the Comments group
  3. Comments group on the Ribbon

  4. Enter the comment
  5. Entering a cell comment

  6. Click outside the comment area. A triangle appears in the corner of the cell indicating the existence of a comment. The comment can be viewed by pointing to the cell

To permanently display the comment:

  1. Select the cell
  2. Click Show/Hide Comment from the Comments group on the Review tab
  3. Click Show All Comments for all comments to be displayed

The Next and Previous buttons in the Comments group can be used to navigate comments within the workbook.

Editing a comment

  1. Select the cell containing the comment
  2. Click the Edit Comment button from the Comments group on the Review tab
  3. Edit the comment
  4. Click outside the comment area

Comment boxes can be resized using one of the eight sizing handles around the border of the comment.

Delete a comment

  1. Select the cell containing the comment to be deleted
  2. Click the Delete button from the Comments group on the Review tab

Follow us on

Facebook  Twitter  You Tube