• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Spreadsheet Essentials > Adding Cell Comments

Adding Cell Comments

To help document the assumptions underlying a calculation or to explain the meaning of a complex formula, you can attach a comment to any cell. Comments are visible only when you want them to be.

To create and manage comments

1.
To attach a comment to a cell, select the cell and choose Insert > Comment.

A text box appears. If set in the General section of the Preferences dialog box (Figure 9.15), the User name appears in the text box to identify the comment's author. If you wish, you can delete it.

Figure 9.15. If specified in Preferences, the User name is automatically attached to each comment.


2.
Enter your comment in the box. When you're finished, click any other cell.

The comment text box closes and a small triangle appears in the cell's upper-right corner to show that it has an associated comment (Figure 9.16).

Figure 9.16. A commented cell is marked with a tiny triangle.


3.
To view comments, do one of the following:

  • To view a specific comment, rest the cursor over the cell (Figure 9.17).

    Figure 9.17. A comment appears when you move the cursor over the cell to which it is attached.


  • To view all the comments in a worksheet, choose View > Comments. (To hide the comments, choose View > Comments again.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint