excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Car Tips
Cooking Tips
ExcelTips (ribbon) Tips
Legal Tips

Newest Tips

Controlling How Excel Adjusts Capital Letters

Numbers Mysteriously Divided by 100

Counting Unique Names

Copying Filtering Results

Centering Your Worksheet Data

Displaying Comment Boxes where You Want Them

Turning the Formula Bar On and Off

 

Specifying a Print Order for Pages

Summary: If a printout of your worksheet requires multiple pages, you may want to specify the order in which Excel prints those pages. This is done by using the Page Setup dialog box, as illustrated in this tip.

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.
  3. Make sure the Sheet tab is selected. (Click here to see a related figure.)
  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.

Related Tips:

Document and Annotate! One of the easily overlooked tools provided by Word is the ability to add footnotes and endnotes to your documents. WordTips: Footnotes and Endnotes is the definitive resource guide to using these tools to enhance your documents. Check out WordTips: Footnotes and Endnotes today!