How to Print on Legal Paper in Excel 2010

To print on legal paper in Excel 2010, go to Page Layout > Size and choose Legal (8.5″ x 14″). You can also set it at print time: File > Print, then pick Legal in the paper size list under Settings. Load legal paper in the printer tray before printing. Office 2010 reached end of support on October 13, 2020; the steps are the same in current Excel.

Quick Answer

Page Layout > Size > Legal > File > Print.

Steps to Print on Legal Paper

1. Open the worksheet.
2. Click Page Layout > Size and choose Legal.
3. Click File > Print and check the preview.
4. Make sure the printer selected supports legal paper and has it loaded.
5. Click Print.

Make the Most of the Longer Page

Setting	Where
Fit all columns on one page	Page Layout > Width: 1 page
Landscape	Page Layout > Orientation
Repeat header row	Page Layout > Print Titles
Narrow margins	Page Layout > Margins > Narrow

Troubleshooting

• Legal isn’t listed: The selected printer doesn’t support it. Choose another printer or More Paper Sizes.
• Prints on letter paper anyway: Check the printer’s own tray setting matches Legal.
• Fitting to one page: See making a sheet fit on one page and optimising printing in Excel.
• Printing a blank grid: See printing an empty grid.

Frequently Asked Questions

Does the setting apply to all sheets?

No, it’s per sheet. Group sheets (Ctrl + click tabs) to change several at once.

What size is legal paper?

8.5 x 14 inches (216 x 356 mm).

How do I switch back?

Choose Letter or A4 in Page Layout > Size.

Summary

1. Choose Page Layout > Size > Legal.
2. Preview in File > Print.
3. Load legal paper and print.
4. Use scaling and titles to use the space well.