Microsoft Office Tutorials and References
In Depth Information
Getting Ready to Print a Worksheet
✦ Adjusting page break positions: In Page Break Preview view, drag a
dashed line to adjust the position of a page break. After you drag a
dashed line, it ceases being a default page break and becomes a manual
page break. Manual page breaks are marked by solid lines, not dashed
lines (see Figure 4-8). You can drag them, too. Excel shrinks the numbers
and letters on your worksheet if you try to squeeze too much data on a
worksheet by dragging a page break.
✦ Inserting a page break: Select the cell directly below where you want
the horizontal break to occur and directly to the right of where you want
the vertical break to be, go to the Page Layout tab, click the Breaks
button, and choose Insert Page Break (see Figure 4-8). Drag a page break
to adjust its position.
✦ Removing a page break: Select a cell directly below or directly to the
right of the page break, go to the Page Layout tab, click the Breaks
button, and choose Remove Page Break (see Figure 4-8).
✦ Removing all manual page breaks: To remove all manual page breaks
you inserted, go to the Page Layout tab, click the Breaks button, and
choose Reset All Page Breaks.