You can control the order in which worksheet pages are numbered and printed when the data doesn't fit on one page. By default, Excel prints pages from the top down and then left to right on the worksheet. You can change the direction to print pages from left to right and then from the top down.
Select the worksheet for which you want to change the printing order.
Select the Page Layout tab, and then select the Dialog Box Launcher
next to Page Setup.
Select the Sheet tab, and then under Page order, select Down, then over or Over, then down.
Tip
The preview box displays the direction of each option.