When you create a new spreadsheet in Microsoft Excel, that spreadsheet will use the default page size for normal documents. This is dictated by your geographic location, and will likely be either Letter or A4.
But sometimes you are going to create a spreadsheet that is quite large, and you may want to fit more rows or columns on the page. This could make you want to use a different, larger type of paper, such as legal. Our tutorial below will show you how to switch to the legal page size in Excel.
If you are switching between paper sizes, then our guide on how to fit all columns on one page in Excel can save you a lot of frustration.
How to Use Legal Paper in Excel for Office 365
The steps in this article were performed on the Excel for Office 365 version of the application, but will also work in most other earlier versions of the program. Note that you may need to change a setting on your printer to get it to print legal paper. The method for doing this can vary across many printers, so you may need to consult the documentation for your specific printer model.
Step 1: Open your spreadsheet in Excel.
Step 2: Click the Page Layout tab at the top of the window.
Step 3: Click the Size button.
Step 4: Select the Legal option..
Now that you know how to switch to the legal page size in Excel, you can make your spreadsheets print on that size paper.
Is your spreadsheet aligned to the left side of the paper, making it look a little strange? Find out how to center your printed spreadsheet so that it looks better.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.