Specify the Page Printing Order in MS Excel


When the information in your worksheet will not fit on a single page, Excel will break it up for you at row and column boundaries, and then it will print your data on multiple pages. You cannot control the order in which Excel will pring pages.

Suppose that the data in your worksheet is both too wide AND too long to fit on a single sheet. Now it will take four pages to print. The first pages are always the information at the tope left-hand corder of your print area. You CAN control whether Excel prints the information beneath page one as page or the information to the right of the page as page two.

Follow the steps below to learn how:

 

  1. On your Ribbon, click the Page Layout tab.
  2. In the Page Setup group, click the small icon in the lower right-hand corner to display the Page Setup dialog box.
  3. Be certain the Sheet tab has been selected.
  4. In the Page Order area of the dialog box, specify how you would like Excel to print your pages. Notice that as you make a selection, Excel will show you how your printing will take place.
  5. Click on OK.
  6. Print as you normally would.
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.