Microsoft Office Tutorials and References
In Depth Information
Inserting and removing manual page breaks
Figure 11-14 Page Break Preview shows default page breaks with heavy dashed lines that you
can reposition by dragging them.
Note
After you apply any page setup options, Excel displays dashed lines in Normal view
wherever a page break will occur. If you’d rather not see these lines, click the File tab,
click Options, select the Advanced category, and in the Display Options For This
Worksheet section clear the Show Page Breaks check box. Note that you cannot change this
option while Page Break Preview is active.
If you attempt to extend the dimensions of a page beyond the maximum width or depth
specified for the current page setup, Excel scales the worksheet to make it it. You can see
the adjusted Scale percentage value in the Scale To Fit group on the Page Layout tab on
the ribbon.
If, after trying different page breaks, you want to revert to the automatic page breaks
(heavy dashed lines), drag the manual page breaks (solid lines) to the left past the row
headers or up past the column headers. After you remove all manual page breaks, the
automatic breaks reappear in their default locations.
Inserting and removing manual page breaks
Spreadsheet pagination can be problematic, given that rows and columns of numbers often
don’t it into the 8.5-by-11-inch world of printing. This is why Excel provides yet another
Search JabSto ::




Custom Search