Microsoft Excel spreadsheets often require a lot of formatting to make them appear correctly on your computer screen. But you may be wondering how to switch to legal paper in Excel if you want to print on that size paper.
Printing in Excel has always been a little tricky, because there are a lot of factors that affect the way your spreadsheet looks when it’s sent to a printer.
By default, Excel is going to use the letter or A4 paper size, which may not be ideal for the type of information you are trying to print.
Fortunately Excel does provide a lot of tools for changing the print settings of your document, and one of the settings you can select is the size of paper you are going to use.
Our guide below will show you how to print on legal paper in Excel if you need to use that instead of the current selection.
How to Switch to Legal Paper Size in Excel for Office 365
- Open your workbook.
- Select Page Layout.
- Click Size.
- Choose Legal.
Our guide continues below with additional information on switching to legal paper in Excel, including pictures of these steps.
How to Print on Legal Paper in Excel
The steps in this article were performed in Microsoft Excel for Office 365, but will also work in most other versions of Excel. Note that in some earlier versions of Excel the tab at the top of the window says “Layout” rather than “Page Layout.”
Step 1: Open your Excel spreadsheet.
Step 2: Select the Page Layout tab at the top of the window.
Step 3: Click the Size button in the Page Setup section of the ribbon.
Step 4: Choose the Legal size from the dropdown menu.
You may also wish to change the page orientation as well. You can do that by clicking the Orientation button, then choosing either the Portrait or Landscape option.
Find out how to center horizontally when printing in Excel if you would like your data to appear at the center of the page instead of aligning to the left.
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.