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 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.

Notice 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.
  
  

To 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.