'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Print an Excel Worksheet on Legal-Size Paper
Question details
The user needs to print an Excel worksheet on 8.5-by-14-inch legal-size paper, but the option is missing from the application's print settings.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Formatting and printing a spreadsheet on a specific legal paper size.
- Observed behavior
- Excel does not display the legal paper-size option in the print or page layout menus.
Verify that your physical printer supports legal-size paper (8.5 x 14 inches) and that the correct paper is properly loaded into the printer tray.
Select Legal Paper Size in Page Layout
Use the standard Excel Page Layout settings to apply the legal paper size to your worksheet before printing.
Excel pulls available paper sizes directly from your connected printer. If your printer supports it, you can easily change the size from the top ribbon.
Navigate to the 'Page Layout' tab on the Excel ribbon.
Click on 'Size' in the Page Setup group and select 'Legal' from the dropdown list.
Go to File > Print to check the print preview and ensure your worksheet fits correctly on the legal-size layout.
Create a Custom Paper Size or Update Printer Driver
If the Legal size option is completely missing from Excel, you will need to add a custom size or update your printer driver so Windows recognizes the format.
Print Spreadsheets on Any Paper Size with WPS Office
WPS Office offers intuitive page layout tools, allowing you to easily adjust paper sizes, set print areas, and preview your worksheets before printing, saving you time and hassle.
- 1. Open Your Workbook: Launch WPS Spreadsheet and open the file you wish to print.
- 2. Navigate to Page Layout: Click on the 'Page Layout' tab located on the top navigation ribbon.
- 3. Select the Legal Size: Click 'Size' and choose 'Legal (8.5 x 14 in)' from the list.
- 4. Print Your Document: Press Ctrl + P to open the Print dialog, verify the preview, and click 'Print'.
Frequently Asked Questions
Why is the Legal paper size missing from my Excel print options?
Excel generates its paper size options based on the default printer selected. If your currently selected printer does not physically support legal paper, or if it is using a generic basic driver, the Legal option will not appear in the menu.
What are the exact dimensions of legal-size paper?
Standard legal-size paper measures 8.5 inches in width by 14 inches in length, which is equivalent to 216 x 356 millimeters.
Can I force Excel to fit everything on one legal-size page?
Yes. After setting your paper size to Legal, go to File > Print. At the bottom of the settings list, click on 'No Scaling' and change it to 'Fit Sheet on One Page'.
Does changing the default printer affect my Excel paper sizes?
Yes. If you switch your default Windows printer to 'Microsoft Print to PDF' or another printer that inherently supports more sizes, you will see Legal and other paper dimensions reappear in Excel's Page Layout menu.
