How to Print on Legal Paper in Excel 2010

We have written about ways to adjust the print settings in Excel 2010 so that all of your columns will print on one sheet, which can be the best solution if your spreadsheet is just barely too large to fit on a sheet of letter-sized paper. But if you have a lot of columns or a lot of data, then this can result in small text that is difficult to read. If you need to keep all of those columns on one page, however, then a better option might be to simply use larger paper, such as legal paper. Fortunately this is a setting that you can adjust in Excel rather easily. So continue reading below to learn how to change the paper size for a spreadsheet in Excel 2010.

Black and white laser printers are good choices for homes or businesses with a lot of printing needs. Check out a good one here.


How to Print on 8.5″ by 14″ Paper in Excel 2010

Note that individual printers may require additional changes in order to print on legal-sized paper. This can often mean using the manual-feed option on the printer, or using a different paper tray on larger printers. Following the steps below will change the paper size setting in Excel, but it may not change the paper size setting for your printer. If your printer will not print on legal paper, then you will need to consult the documentation for your printer model to learn how to print on a paper size other than letter.


Step 1: Open your spreadsheet in Excel 2010.


Step 2: Click the Page Layout tab at the top of the window.

click the page layout tab



Step 3: Click the Size button in the Page Setup section of the ribbon at the top of the window, then click the Legal option.

how to print on legal paper in excel 2010



You can adjust some of the other printing and layout options from this location, including the size of the margins and the orientation of the sheet. Another helpful adjustment when printing Excel spreadsheets is to print the top row on every page. This adjustment can make it much easier to determine what certain data is on additional pages of a printed document.

Sign up for a free trail of Amazon Prime to see if free two-day shipping and video streaming are something that will benefit you. newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.