Microsoft Office Tutorials and References
In Depth Information
Important Be sure to click a row header or column header when you want to insert a single
page break. If you view a workbook in Page Break Preview mode, right-click a cell within the
body of a worksheet, and then click Insert Page Break, Excel creates both a vertical page break
to the left of the selected cell and a horizontal page break above the selected cell.
To move a page break, drag the line representing the break to its new position. Excel
will change the worksheet’s properties so that the area you defined will be printed on
a single page.
Changing the Page Printing Order for Worksheets
When you view a document in Page Break Preview mode, Excel indicates the order in
which the pages will be printed with light gray words on the worksheet pages. (These
indicators appear only in Page Break Preview mode; they don’t show up when the
document is printed.) You can change the order in which the pages are printed by displaying
the Page Layout tab, clicking the Page Setup dialog box launcher, and displaying the
Sheet page of the Page Setup dialog box.