Selecting a Print Area
You can tell Excel what part of the worksheet you want to print using the Print Area option. This option lets you single out an area as a separate page and then print that page. If the area is too large to fit on one page, Excel breaks it into multiple pages. If you do not select a print area, Excel prints either the entire worksheet or the entire workbook, depending on the options set in the Print dialog box.
To Include or Not to Include?
When deciding which cells to select for your print area, make sure you do not include the title, the subtitle, and the column and row headings in the print area. If you do, Excel may print the labels twice. Instead, print your titles and headings on each page of your printout by following ...
Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
