Specifying an Order for Page Printing

When the information you have in worksheet won't fit on a single page, Excel automatically breaks it up--at row or column boundaries--and prints the information on multiple pages. You can control the order in which Excel prints pages.

For instance, let's say the information in your worksheet is both too wide and too long to fit on a single sheet. Instead, the printed material will take four pages to print. The first page printed will always be the information at the top left corner of the print area. You can control whether Excel prints the information beneath page one as page two, or the information to the right of page one as page two. Follow these steps:

1. Choose Page Setup from the File menu. Excel displays the Page Setup dialog box.
2. Make sure the Sheet tab is selected. (Click here to see a related figure.)
3. In the Page Order area of the dialog box, specify how you want Excel to print your pages. (Notice that as you make a selection, Excel graphically shows how your printing will occur.)
4. Click on OK.
5. Print as normal.

The steps are slightly different in Excel 2007:

1. Select the Page Layout tab of the ribbon.
2. Click the small icon in the lower-right corner of the Page Setup group. Excel displays the Page Setup dialog box.
3. Make sure the Sheet tab is selected.
4. In the Page Order area of the dialog box, specify how you want Excel to print your pages. (Notice that as you make a selection, Excel graphically shows how your printing will occur.)
5. Click on OK.
6. Print as normal.