How to Print an Excel Worksheet in Landscape and Fit It to One Page
Question details
The user needs to change an Excel worksheet to landscape orientation and scale its print area to fit one page or a specified number of pages.
- Product
- Microsoft Excel or WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The worksheet contains more columns or rows than fit well on a portrait page, and the user wants a controlled landscape print layout.
- Observed behavior
- The worksheet needs to print in landscape orientation with its content fitted to one page or the required number of pages.
Select the worksheet you want to print and check whether an existing print area includes all required cells. Remove or update an incorrect print area before changing the scaling settings.
Set landscape orientation and fit the worksheet to the required pages
Use this method when the worksheet is too wide for portrait printing or must fit on one page horizontally and vertically.
Open the workbook in WPS Spreadsheets, select the worksheet, and click the Page Layout tab.
In the Page Setup group, click Orientation and select Landscape.
In the Scale to Fit section, set Width to 1 page and Height to 1 page for a single-page printout. Choose different page counts if the worksheet should span multiple pages.
Use Print Area to set or clear the selected range, and adjust Margins or reduce the font size if important content is still crowded.
Click File, choose Print, review the preview, and select Print when the worksheet layout is correct.
Print Excel-compatible worksheets in landscape with precise page scaling
WPS Office lets you open Excel-compatible workbooks, switch worksheets to landscape orientation, define a print area, set the required page width and height, and verify the result in Print Preview before printing.
- 1. Open the workbook: Launch WPS Office, open the Excel-compatible .xlsx or .xls file, and select the worksheet to print.
- 2. Set landscape mode: Go to Page Layout, click Orientation, and choose Landscape.
- 3. Configure scaling: In Scale to Fit, set Width and Height to the desired number of pages, such as 1 page by 1 page.
- 4. Check the print preview: Select File, click Print, and review the preview to confirm that the columns, rows, and page breaks are correct.
Frequently Asked Questions
How do I print an Excel worksheet horizontally?
Open the worksheet, go to Page Layout, select Orientation, and choose Landscape. Use File > Print to confirm the horizontal layout in the preview.
How can I fit all Excel columns on one printed page?
In Page Layout, find Scale to Fit and set Width to 1 page. Set Height to 1 page as well if all rows must fit on a single page; otherwise, leave Height automatic or choose multiple pages.
Why is the worksheet text too small after fitting it to one page?
The worksheet may contain too many columns or rows for one page. Set Height to multiple pages, reduce the print area, narrow the margins, or adjust the font size to improve readability.
How do I print only part of an Excel worksheet?
Select the cells to print, open Page Layout, choose Print Area, and select Set Print Area. Then open File > Print to verify that only the selected range appears.
Can WPS Office print an Excel file in landscape format?
Yes. Open the .xlsx or .xls file in WPS Spreadsheets, choose Page Layout > Orientation > Landscape, configure Scale to Fit, and print from File > Print.
