How to Change the Page Order in Excel 2013

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.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.