Microsoft Office Tutorials and References
In Depth Information
Setting and viewing page breaks
Setting and viewing page breaks
Excel determines where one printed page ends and the next
begins based on the page size, margins, and orientation;
however, the page breaks Excel sets might not work for a particular
worksheet. You might want to place a chart or table 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 mode, you can change the location of any existing page
breaks to ensure that your worksheets print exactly the way that
you want.
view current page breaks
1 Click the View tab.
2 Click Page Break Preview.
Search JabSto ::

Custom Search