Microsoft Office Tutorials and References
In Depth Information
Formatting comments
Excel inserts a comment that points to the active cell. Initially, the comment consists
of your name, as specifi ed in the General tab of the Excel Options dialog box (choose
File
Options to display this dialog box). You can delete your name from the comment, if
you like. 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 point out specifi c 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 (or activate the cell), the
comment becomes visible.
You can force a comment to be displayed even when its cell is not activated. Right-click the
cell and choose Show/Hide Comments. Although this command refers to “comments” (plu-
rail), it affects only the comment in the active cell. To return to normal (make the comment
appear only when its cell is activated or the mouse point hovers over it), right-click the cell
and choose Hide Comment.
You can control how comments are displayed. Choose File ➪ Options and then select the Advanced tab of the
Excel Options dialog box. In the Display section, select the No comments or indicators option under For cells with
comments, show.
Formatting comments
If you don’t like the default look of cell comments, you can make some changes. Right-click
the cell and choose Edit Comment. Select the text in the comment and use the commands
of the Font and the Alignment groups (on the Home tab) to make changes to the comment’s
appearance.
Search JabSto ::




Custom Search