New spreadsheets that you create in Microsoft Excel will be in the portrait orientation by default. But if you have a spreadsheet with more columns than can easily fit on a page, then you may be wondering how to switch from portrait to landscape in Excel for Office 365.
Properly formatting the appearance of cells in Excel can involve things like switching from general to currency formatting, adjusting the number of decimal places, adjusting your fonts, and more.
But when you need to print out a spreadsheet you will discover that there is an entire other set of formatting choices that you need to make.
Adjusting the printing settings in Excel can involve repeating the top row on every page, choosing to print gridlines, trying to fit all of your columns on one page, or adjusting the page orientation.
Luckily many of these changes can be found on the Page Layout tab, including the orientation setting.
How to Switch from Portrait to Landscape in Excel
- Open your spreadsheet.
- Select Page Layout.
- Click Orientation.
- Choose Landscape.
Our article continues below with additional information on how to switch from portrait to landscape in Excel, including pictures of these steps.
How to Change Page Orientation in Excel for Office 365 (Guide with Pictures)
The steps in this article were performed in the Microsoft Excel for Office 365 version of the application, but will work for most other versions of Excel as well.
Step 1: Open the spreadsheet that you wish to edit.
Step 2: Select the Page Layout tab at the top of the window.
Step 3: Click the Orientation button in the Page Setup section of the ribbon.
Step 4: Choose the Landscape option from the orientation drop down menu.
As we mentioned earlier, there are many other print settings that you might need to change. One simple way to find many of them is to click the small Page Setup button at the bottom-right corner of the Page Setup section of the ribbon.
On that menu you will find several tabs with a variety of print and page settings that you can change for your spreadsheet.
Matthew Burleigh has been a freelance writer since the early 2000s. You can find his writing all over the Web, where his content has collectively been read millions of times.
Matthew received his Master’s degree in Computer Science, then spent over a decade as an IT consultant for small businesses before focusing on writing and website creation.
The topics he covers for MasterYourTech.com include iPhones, Microsoft Office, and Google Apps.
You can read his full bio here.