Lesson 23: Inserting, Viewing, and Editing Comments

/en/excel2003/sorting-lists/content/

Introduction

By the end of this module, you should be able to:

  • Insert comments
  • View comments
  • Edit comments
  • Delete comments
  • Show and hide comments

Inserting, viewing, and editing comments

There may be times when you'd like to leave a reminder or note in a spreadsheet for yourself or someone else. Excel allows you to easily insert comments in a cell, as well as view and edit these comments.

To insert a comment:

  • Select the cell where you would like to add a comment.
  • Choose Insert action Comment from the main menu.
  • Enter your comment into the text box that appears next to the selected cell.
  • Click in any other cell. The comment box will disappear.

TipNotice the small, red triangle in the upper-right corner of the selected cell. This triangle indicates that there is a comment associated with the cell.

To edit, delete, show, or hide a comment:

  • Right-click the cell with a comment.
  • Select Edit Comment, Delete Comment, or Show/Hide Comments from the menu.

    Comments

TipTo hide a comment after choosing to show it, simply right-click the cell and choose Hide Comment from the menu.

Challenge!

If you have not already done so in a previous challenge, download and save the Employee Sales spreadsheet.

  • Open the Employee Sales spreadsheet.
  • Add the following comment to the cell with Jane Smith's February sales information:
    • Record month—Sold 19 cars!
  • Add the following comment to the cell with Thomas Morrison's June sales information:
    • Lowest monthly sales—out sick.
  • Delete the comment associated with Jane Smith's February sales record.
  • Save and close the spreadsheet.

/en/excel2003/inserting-hyperlinks/content/