Chapter 4: Working with Excel Ranges and Tables
4
click the comment’s border to select it as a Shape (or Ctrl+click the comment to select it as
a Shape). Type Change Shape into the Tell Me What You Want to Do box, and choose a new
shape for the comment. Figure 4.18 shows a cell comment with a nonstandard shape.
FIGURE 4.18
Cell comments don’t have to be rectangles.
Reading comments
To read all comments in a workbook, choose Review ➪ Comments ➪ Next. Keep clicking
Next to cycle through all of the comments in a workbook. Choose Review ➪ Comments ➪
Previous to view the comments in reverse order.
See Chapter 7, “Printing Your Work,” for information about including comments on your printouts.Hiding and showing comments
If you want all cell comments to be visible (regardless of the location of the mouse), choose
Review ➪ Comments ➪ Show All Comments. This command is a toggle; select it again to
hide all cell comments.
To toggle the display of an individual comment, select its cell and then choose Review ➪
Comments ➪ Show/Hide Comment.
Editing comments
To edit the text in a comment, activate the cell, right-click, and then choose Edit Comment
from the shortcut menu. Or select the cell and press Shift+F2. After you make your
changes, click any cell.