How to Change the Paper Size in Excel to 11 by 17

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Specify page size in Excel's layout or just before printing.

For large spreadsheets, Microsoft Excel 2013 supports tabloid-sized pages, so you can print on paper measuring 11 by 17 inches in either landscape or portrait mode. Whenever you change the page size in Excel, examine your margin settings and take a look at the page breaks and the print job preview. This will ensure your print job comes out the way you want it the first time, without wasting paper or ink.

Advertisement

Step 1

Paper sizes appear under the Page Layout tab.

Click the "Page Layout" tab after opening any Excel worksheet and then click the "Size" icon. Select "Tabloid" for an 11-by-17 inch layout.

Advertisement

Video of the Day

Step 2

Select "Portrait" or "Landscape" page orientation.

Click the "Orientation" icon under the Page Layout tab and select either "Portrait" or "Landscape."

Advertisement

Step 3

Specify margin sizes under the Page Layout tab.

Click the "Margins" icon to specify margin sizes. Excel 2013 has three margin styles -- Normal, Wide and Narrow -- with the margins, headers and footer dimensions listed. You can also specify your own margins by clicking "Custom Margins."

Advertisement

Step 4

Limit a print area to a specific range of cells if desired.

Drag the cursor over the cells you want printed if you want to print only a portion of the worksheet. Select "Print Area" under the Page Layout tab, then click "Set Print Area." The cells that you don't highlight won't be printed. If you later want to change the selected cells, or print the entire worksheet, select "Clear Print Area."

Advertisement

Advertisement

Step 5

Use Page Break Preview to see the layout of multiple pages.

Click the "View" tab and select "Page Break Preview" to see how your print job will look. If you are printing a large worksheet, make sure the columns appear on each page as you intended. For example, if the columns or margins are too wide, the column you wanted on Page 1 may appear at the beginning of Page 2. If necessary, you can modify the column and row widths using this layout view.

Advertisement

Step 6

Specify page size and other options under the Print menu.

Click the "File" tab when you are ready to print the worksheet. Select "Print" from the menu and select your printer. A preview of the print job appears, as well as your print settings. If the "Tabloid" page size isn't selected here, click the current page size and select "Tabloid" from the drop-down menu. Select the number of pages you want printed, whether you want them collated or not, and any other settings you want to specify. Turn on your printer and click the "Print" button.

Video of the Day

Advertisement

Advertisement

references