O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required