Controlling Where Pages Break
If your worksheet is too large to fit on one page, Excel splits the work over two or more pages. Excel makes the split based on your current page dimensions, margins, and cell widths and heights. Excel always splits the worksheet at the beginning of a column (vertically) and/or row (horizontally), so the information in a cell is never split between two pages.
An automatic page break appears as a dashed line with short dashes in your worksheet. These dashed lines run down the right edge of a column.
If the automatic page breaks are not right for your worksheet, one of the many ways to make adjustments is to override Excel's defaults. The worksheet still prints on two or more pages, but you can control where each new ...
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours 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.
