Office 2007 Bible

Adding Comments to Cells

Documentation that explains certain elements in the worksheet can often be helpful. One way to document your work is to add comments to cells. This feature is useful when you need to describe a particular value or explain how a formula works.

To add a comment to a cell, select the cell and then choose Review Comments New Comment. Alternatively, you can right-click the cell and choose Insert Comment from the shortcut menu. Excel inserts a comment that points to the active cell. Initially, the comment consists of your name. Enter the text for the cell comment and then click anywhere in the worksheet to hide the comment. You can change the size of the comment by clicking and dragging any of its borders. Figure 14-24 shows a cell with a comment.

Figure 14-24. You can add comments to cells to help clarify important items in your worksheets.

Cells that have a comment display a small red triangle in the upper-right corner. When you move the mouse pointer over a cell that contains a comment, the comment becomes visible.

Tip

You can control how comments are displayed. Access the Advanced tab of the Excel Options dialog box. In the Display section, an option lets ...