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.

birthday t-shirts for boys
vintage t rex t-shirt