Chapter 4: Working with Excel Ranges and Tables
4
You can control the way 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 from the For Cells with
Comments, Show list.
FIGURE 4.16
You can add comments to cells to help point out specific items in your worksheets.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.You can also display an image inside a comment. Right-click the cell and choose Edit Comment. Then right-click the
comment’s border (not the comment itself) 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.