Page 136 - Excel 2007 Bible

09_044039 ch05.qxp 11/21/06 10:56 AM Page 93
Working with Cells and Ranges
FIGURE 5.17
Cell comments don’t have to be rectangles.
Reading comments
To read all of the comments in a workbook, choose Review ➪ Comments ➪ Next. Click this command 5
repeatedly to cycle through all the comments in a workbook. Choose Review ➪ Comments ➪ Previous to
view the comments in reverse order.
Hiding and showing comments
If you want all cell comments to be visible (regardless of the location of the cell pointer), 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 comments, select its cell and then choose Review ➪ Comments ➪
Show/Hide Comment.
Editing comments
To edit a comment, activate the cell, right-click, and then choose Edit Comment from the shortcut menu.
When you’ve made your changes, click any cell.

Deleting comments
To delete a cell comment, activate the cell that contains the comment and then choose Review ➪
Comments ➪ Delete. Or, right-click and then choose Delete Comment from the shortcut menu.

93