Setting and Viewing Page Breaks

Excel determines where one printed page ends and the next begins based on your page size, margins, and orientation; however, the page breaks Excel sets might not work for a particular worksheet. You might want to have a chart or table placed on its own sheet, or you might want to force two separate tables onto one printed page. You can display all existing page breaks by opening your worksheet in Page Break Preview mode, which displays the page breaks as blue lines. If the blue lines are dashed, they represent an automatic page break; if the blue lines are solid, they represent a manually set page break. While in Page Break Preview, you can change the location of any existing page breaks to ensure your worksheets ...

Get Microsoft® Office Excel® 2007 Plain & Simple now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.