How to Print a Selected Excel Range to One Letter Landscape PDF Page in WPS Office
Question details
The user needs to export a selected Excel range as a PDF on exactly one Letter-sized landscape page, using VBA or page layout settings to set the print area and apply automatic scaling.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user has a selected cell range in a spreadsheet and wants it to appear on a single Letter landscape PDF page without manual resizing.
- Observed behavior
- Before applying the print area and FitToPages settings, the selected range may export to multiple pages or use the wrong paper size and orientation.
Open the workbook in WPS Office Spreadsheets, select the exact cells you want to export, and make sure no manual page breaks are active because they can override the fit-to-one-page setting.
Use Page Layout Settings to Print a Selected Range on One Letter Landscape PDF
The fastest manual method in WPS Spreadsheets: set the selected range as the print area, apply Letter landscape and fit-to-one-page scaling, then export to PDF.
Open the workbook in WPS Office Spreadsheets and select the exact cells you want to include in the PDF.
Go to Page Layout > Print Area > Set Print Area so only the selected range will be printed or exported.
On the Page Layout tab, click Size > Letter, then click Orientation > Landscape.
In the Page Layout tab, set the Scale to Fit options to Width: 1 page and Height: 1 page.
Click File > Export to PDF, choose a save location, and confirm the paper size and layout before saving.
Use VBA to Set the Print Area and Export a Fitted Letter Landscape PDF
Use this macro method when you need a repeatable, one-click export that applies the same page setup automatically.
Print a Selected Excel Range to One Letter Landscape PDF in WPS Office
WPS Office Spreadsheets lets you set a selected range as the print area, apply Letter landscape orientation, scale the content to exactly one page, and export it as a PDF without changing the original workbook.
- 1. Open the workbook and select the range: Open the Excel file in WPS Office Spreadsheets and highlight the cells you want to export.
- 2. Set the print area: Go to Page Layout > Print Area > Set Print Area.
- 3. Configure Letter landscape and fit to one page: Set Size to Letter, Orientation to Landscape, and Scale to Fit Width and Height to 1 page each.
- 4. Export as PDF: Click File > Export to PDF, choose a file name, and save the selected range as a one-page PDF.
Frequently Asked Questions
Can I print a selected range to one Letter landscape PDF in WPS Office without using VBA?
Yes. Select the range, click Page Layout > Print Area > Set Print Area, set Size to Letter and Orientation to Landscape, set Scale to Fit to 1 page wide by 1 page tall, then click File > Export to PDF.
Why does my selected range still export to multiple pages?
Check that the Scale to Fit settings are Width 1 page and Height 1 page, and that page breaks are not overriding the print area. In VBA, confirm FitToPagesWide and FitToPagesTall are both set to 1.
Does WPS Office support the Excel VBA code for PageSetup and ExportAsFixedFormat?
Yes. WPS Office Spreadsheets supports Excel-compatible macros. Press Alt+F11 to open the editor, insert a module, and run the macro with the desired range selected.
What is the actual size of Letter paper in landscape?
Letter paper is 8.5 x 11 inches; in landscape orientation the printable page is 11 x 8.5 inches. WPS Spreadsheets uses xlPaperLetter for this paper size.
Can I set the PDF to fit only horizontally and allow more pages vertically?
Yes. Set Width to 1 page and Height to automatic, or in VBA set FitToPagesWide = 1 and FitToPagesTall = False.
