How to Change the Page Order in Excel 2013

Last updated on May 18th, 2023 at 12:29 am

It’s very common for an Excel spreadsheet to be too large to fit on one page. Additional cells are then pushed to another page and, depending upon how your data is organized, you might need to manually shuffle the printed sheets so that they are in the order which is most helpful to the reader.

One of the biggest issues with printing large spreadsheets comes about because there are too many columns to fit across one page. Unfortunately the default printing behavior in Excel will cause those additional columns to print at the end of the sheet, after all of the rows have printed first. if you would like to change that behavior, follow the tutorial below to change the print order for pages in your spreadsheet.


How to Change the Order in Which Pages Print in Excel 2013

The steps in this guide are going to change the order in which the page of your spreadsheet print. By default Excel will print your data by first going down your spreadsheet, then going over. So if there are too many columns to fit on one page, the the additional columns will be printed after all of the rows have first been printed. The steps in this article will change that setting so that all of the columns are printed before moving down and printing the next set of rows.

Step 1: Open your spreadsheet in Excel 2013.


Step 2: Click the Page Layout tab at the top of the window.

click the page layout tab



Step 3: Click the small Page Setup button at the bottom-right corner of the Page Setup section in the ribbon.

click the page setup button



Step 4: Click the Sheet tab at the top of the Page Setup window.

sheet tab on page setup menu



Step 5: Select the Over, then down option under the Page order section of the menu. Click the OK button to apply your changes.

how to change page order in excel 2013



You can see the order in which your spreadsheet pages will print by either going to the Print Preview or by clicking the View tab and selecting the Page Break Preview option.

excel 2013 page break preview



Are you looking for other ways in which you can adjust the settings for your printed spreadsheets? Our Excel printing guide can provide you with some helpful options that can assist with that.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides