Written by Allen Wyatt (last updated June 11, 2022)
This tip applies to Excel 97, 2000, 2002, and 2003
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:
Figure 1. The Sheet tab of the Page Setup dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2979) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Specifying an Order for Page Printing.
Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!
Need a full-page border on your Excel printouts? It's not as easy to get one as you might wish. There are a few ways you ...
Discover MoreWhen you print out a filtered worksheet, you may want some sort of printed record as to what filtering was applied to the ...
Discover MoreWant a list of all the worksheets in your workbook? Here's a short, handy macro that will place all the worksheet names ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments