Adjusting Page Breaks

When you print a workbook, Excel determines the page breaks based on the paper size and margins and the selected print area. To make the pages look better and break information in logical places, you may want to override the automatic page breaks with your own breaks. However, before you add page breaks, try these options:

  • Adjust the widths of individual columns to make the best use of space (see Lesson 20).

  • Consider printing the workbook sideways (using Landscape orientation).

  • Change the left, right, top, and bottom margins to smaller values.

If after trying these options you still want to insert page breaks, Excel 97 offers you an option of previewing exactly where the page breaks appear and then adjusting them. Follow these ...

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.