Set the printing order of worksheet pages

You can control the order in which worksheet pages are numbered and printed when the data does not fit on one page. By default, Excel prints pages from the top down and then left to right on the worksheet, but you can change the direction to print pages from left to right and then from the top down.

  1. Click the worksheet for which you want to change the printing order.
  2. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher Button image next to Page Setup.

Excel Ribbon Image

  1. On the Sheet tab, under Page order, click Down, then over or Over, then down.

 Tip   The direction of each option is displayed in the preview box.

 
 
Applies to:
Excel 2007