SECTION 2
Lesson 2.3 Editing Tools

   

 

 

Sometimes it is necessary to include explanations for data or formulas, especially if your worksheet is very complex. Comments allow you to place explanations or definitions where ever your worksheet needs them.

 

If a cell contains a comment, there will be a small red triangle in the upper right corner.

 

 

If you let your mouse pointer hover over the cell, the comment will be displayed in a light yellow box.

 

 

It is easy to insert comments into your Excel worksheet. Just choose the cell that you want to add a comment to, and click on it, making it the active cell. Choose Insert -> Comment from the Insert menu on the menu bar.

 

 

A comment box will appear with a name (normally the computer’s owner) and a flashing cursor.

 

You can resize the comment box by moving your mouse pointer to one of the small circles on the outside edge of the box. When your pointer turns into a short double headed arrow, you can hold the left mouse button and drag to increase or decrease the size of the box.

 

You can change the name to whatever you want by clicking on it and typing a new name. You can also click in the main body of the box and type the comment or explanation that you need.

 

When you are finished, left click outside the comment box and the comment will disappear, leaving a small red triangle in the upper right corner of the cell.

 

 

If you ever need to edit a comment, just select the cell with the comment you want to change, and right click on it.

 A menu will appear with options to Edit Comment and Delete Comment.

 

Clicking the Edit Comment option will open the comment box for editing, while clicking the Delete option will remove the comment and the small red triangle from the cell.