Printing can be one of the more annoying tasks that you undertake on a regular basis, and that is no more evident than in Excel. You can freely create spreadsheets of any size, but they don’t always conform to the size of the paper on which you want to print them. So if you want to force a workbook in Excel 2011 to fit on only one page, you can do so by following the steps outlined below.
Fit a Spreadsheet to One Page in Excel 2011
While we are going to focus on fitting a spreadsheet on only one page in Excel 2011, you can also follow this same procedure to customize the number of pages that print out. For example, you could configure an Excel worksheet to print all of the columns on one page, but spread out the rows on additional pages. This is likely a better solution if you are going to be printing a large spreadsheet with a high number of rows.
Step 1: Open the spreadsheet in Excel 2011.
Step 2: Click File at the top of the screen.
Step 3: Click Print at the bottom of the menu.
Step 4: Check the box to the right of Scaling.
Step 5: Enter a 1 into the fields to the right of Fit to: and by.
Step 6: Click the Print button at the bottom of the menu.
Note that this can result in some very small text if you are fitting a large spreadsheet to one page.
We have previously written about how to print a spreadsheet on just one page in Excel 2010 as well. Read here to learn how.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.