Manage Comments and Create Text Boxes in Excel

To make values in a worksheet more meaningful, it is sometimes necesary to add addition information to a cell. these text notes are usually used to privide additional information about the data or to explain an calculation.

 

Excel offers 2 types of text notes: text boxes and comments. This document explains how to view, create, and manage comments. Comments are hidden until they are viewed.

---

---

How To View a Comment:

A worksheet containing a comment will display a small red triangle in the cell. This red triangle is called a comment indicator.

1. Point to the cell containing the comment indicator.
2. The comment box should appear.

To View all of the comments on a worksheet:

1. From the View menu choose Comments.
2. All of the comment boxes should appear.

How to Add a Comment:

1. Select the desired cell.
2. From the Insert menu choose Comment.
3. Enter the text in the comment box.
4. click outside the comment box.
   • The red indicator should appear in that cell.

How to Manage Comments:

1. From the Tools menu choose Options...
2. Click the View tab.
3. Under Comments, select the desired option.
4. Click OK.

How to Create a Text Box:

1. Display the Drawing toolbar.
2. Click the Text Box button on the Drawing toolbar.
3. Point to the desired lcation for the text box.
4. Click, hold, and drag the pointer to create the text box.
5. Enter the desired text in the text box.
6. Click outside the text box.