Chapter 4: Working with Cells and Ranges
97
- Click the dialog box launcher in the Page Layout ➪ Page Setup group. This is the
small icon to the right of the Page Setup group name. Clicking this icon displays the Page
Setup dialog box. - In the Page Setup dialog box, click the Sheet tab.
- Make your choice from the Comments drop-down control: At End of Sheet, or As
Displayed on Sheet (see Figure 4.19).
FIGURE 4.19
Specifying how to print cell comments.- Click OK to close the Page Setup dialog box. Or, click the Print button to print the
worksheet.
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.Selecting comments ...................................................................................................
To quickly select all cells in a worksheet that contain a comment, choose Home ➪ Editing ➪ Find
& Select ➪ Go to Special. Then choose the Comments option and click OK.