Set the printing order of worksheet pages

You can control the order in which worksheet pages are numbered and printed when the data does not fit on one page. By default, Excel prints pages from the top down and then left to right on the worksheet, but you can change the direction to print pages from left to right and then from the top down.

  1. Click the worksheet for which you want to change the printing order.

  2. Click the Page Layout tab, and then click the Dialog Box Launcher Dialog Box Launcher next to Page Setup.

    Page Setup Dialog Box Launcher

  3. Click the Sheet tab, and then under Page order, click Down, then over or Over, then down.

    Tip: The direction of each option is displayed in the preview box.

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.