• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Excel / How to Change the Page Order When Printing in Excel for Office 365

How to Change the Page Order When Printing in Excel for Office 365

July 2, 2019 By Matt

Getting an Excel spreadsheet to print the way that you want can be a little frustrating. There are a lot of different options that affect they way your data appears on the printed page, and some of those options may not be something you realize until you’ve already printed and discovered that something was wrong.

One such option concerns the order in which your spreadsheet pages are printed. By default, Excel will go down, then over. This means that the left side of the spreadsheet will print first then, if there is any overflow from additional columns, those columns will print next. For spreadsheets that are only a few pages, putting the in order manually typically isn’t a problem. But it can become problematic for large files, so continue below and see how you can switch to the “Over, then down” option instead.

How to Change from “Down, then over” to “Over, then down” When Printing in Excel

The steps in this article were performed in Microsoft Excel for Office 365, but will work in most other recent versions of Excel as well. Note that this setting only applies to the current spreadsheet. Other Excel files won’t be affected by this change.

Step 1: Open your file in Excel.

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

select the page layout tab

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

click the page setup button

Step 4: Choose the Sheet tab at the top of the window.

choose the sheet tab

Step 5: Click the Over, then down option, then click the OK button.

how to change the print order in excel

Find out how to print your filename at the top of every page in Excel so that less confusion will arise should the pages of the spreadsheet become separated.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Select All in Google Docs
  • How to Clear Formatting in Google Docs
  • How to Make Gridlines Darker in Excel 2016
  • Does the Amazon Fire Stick Need Internet?
  • How to Make a Desktop Shortcut for a Google Docs File

Featured Posts

How to Take Off Subject on iPhone

Can I Change the Default Search Engine in Safari on My iPhone?

Where Did the Gridlines Go in Google Sheets?

How to Remove Borders from a Table in Microsoft Word for Office 365

How to Make Your Screen Turn On When You Pick Up Your iPhone

Is There a Fast Way to Enable Airplane Mode on an iPhone 7?

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

Copyright © 2019 SupportYourTech.com