1-866-245-5224 sales@keystonelearning.com

Excel 2003: Inserting & Deleting Comments

Excel 2003: Inserting & Deleting Comments

Comments are a great way to add reminders about your worksheet data. Even though they remain hidden much of the time, comments act like sticky notes containing information about your data that only appear on request.

Inserting Comments

Once you decide which cells you need to flag with notes, getting those notes attached to specific cells is a piece of cake.

Inserting a Comment Using the Menu Bar

     
  1. Select the cell that will contain the comment
     
  2.  
  3. Choose Insert: Comment from the Menu bar
     
  4.  
  5. Enter your comment text
     

Figure 1. Comment Sample

   4.      Click another cell to hide the comment
(the comment can easily be displayed again by hovering your mouse over the red triangle in the upper-right corner of the cell)

Inserting a Comment Using the Shortcut Menu

     
  1. Right-click the cell that will contain the comment
     
  2.  
  3. Choose Insert Comment from the Shortcut menu
     
  4.  
  5. Enter your comment text
      (Comment text can be modified if you select it, then use the formatting options in the Font group on the Home tab)
     
  6.  
  7. Click another cell to hide the comment
      (the comment can easily be displayed again by hovering your mouse over the red triangle in the upper-right corner of the cell)
     

Editing a Comment Using the Menu Bar

     
  1. Select the cell that contains the comment you want to edit
     
  2.  
  3. Choose Insert: Edit Comment from the Menu bar
     
  4.  
  5. Make your edits to the comment
     
  6.  
  7. Click another cell to hide the comment
     

Editing a Comment Using the Shortcut Menu

     
  1. Right-click the cell that will contain the comment
     
  2.  
  3. Choose Edit Comment from the Shortcut menu
     
  4.  
  5. Make your edits to the comment
     
  6.  
  7. Click another cell to hide the comment
     

Deleting Comments

Comments are in no way, shape or form permanent. And, they are just as easy to remove as they are to insert.

     
  1. Right-click the cell that will contain the comment
     
  2.  
  3. Choose Delete Comment from the Shortcut menu