Microsoft Office Tutorials and References
In Depth Information
Setting worksheet options
Figure 11-12 We defined print titles and used Page Layout view to see the results.
To remove your print title definitions, you can return to the Page Setup dialog box and
delete the cell references. You can also use the Define Name dialog box to do this by
pressing Ctrl+F3 and deleting the name Print_Titles. For more information, see “Nam-
ing cells and cell ranges” in Chapter 12.
Printing gridlines and headings
By default, Excel does not print gridlines or row and column headings, regardless of
whether they are displayed on your worksheet. If you want to print gridlines or headings,
select the corresponding Print check box in the Sheet Options group on the Page Layout
tab. You can also select the Gridlines or Row And Column Headings check box on the Sheet
tab in the Page Setup dialog box (which you can see in Figure 11-11).
Printing comments and errors
Comments are annotations you create by clicking New Comment on the Review tab on the
ribbon. To be sure the comments in your worksheet are included with your printout, select
one of the Comments options on the Sheet tab in the Page Setup dialog box (which is
shown in Figure 11-11). If you select At End Of Sheet from the drop-down list, Excel adds a
page to the end of the printout and prints all your notes together, starting on that page. If
you select As Displayed On Sheet, Excel prints the comments as pop-up windows wherever
they are located on a worksheet. The latter option might cause the comments to obscure