Excel 2010 Bible

Chapter 4: Working with Cells and Ranges

95

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” (plural), it

affects only the comment in the active cell. To return to normal (make the comment appear only

when its cell is activated), right-click the cell and choose Hide Comment.

Tip
You can control how comments are displayed. Access the Advanced tab of the Excel Options dialog box. In the
Display section, select the No Comments or Indicators option from the For Cells with Comments, Show list. n

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.

For even more formatting options, right-click the comment’s border and choose Format Comment

from the shortcut menu. Excel responds by displaying the Format Comment dialog box, which

allows you to change many aspects of its appearance, including color, border, and margins.

Tip
You can also display an image inside a comment. Right-click the cell and choose Edit Comment. Then right-
click the comment’s border and choose Format Comment. Select the Colors and Lines tab in the Format
Comment dialog box. Click the Color drop-down list and select Fill Effects. In the Fill Effects dialog box, click
the Picture tab and then click the Select Picture button to specify a graphics file. Figure 4.17 shows a comment
that contains a picture. n

FIGURE 4.17

This comment contains a graphics image.