How to Print on One Page in Excel 2011

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.

open the file menu



Step 3: Click Print at the bottom of the menu.

how to print on one sheet in excel 2011



Step 4: Check the box to the right of Scaling.

check the box to the right of scaling



Step 5: Enter a 1 into the fields to the right of Fit to: and by.

change the settings to one page wide and one page tall



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.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides