Excel.Tips.Net: Specifying an Order for Page Printing

By Allen Wyatt for Excel.Tips.Net

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. 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.

Article Continued Here

This post is excerpted with permission from Excel.Tips.Net

Subscribe to the Free ExcelTips Newsletter with the links below

(for those using Excel 97 through 2003)

(for those using Excel 2007 through 2010)

(Visited 11 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *