How to Set Excel Printer Options to Fit Sheet on One Page in WPS Office
Question details
The user needs to configure page setup and print scaling so an Excel worksheet or workbook prints on one page, and optionally apply that setting to new worksheets or workbooks.
- Product
- WPS Office Spreadsheet (Excel-compatible)
- Device & OS
- not provided
- Scenario
- Printing Excel worksheets or workbooks without splitting columns or rows across multiple pages.
- Observed behavior
- The worksheet currently prints across multiple pages unless page setup and scaling options are applied.
Open the workbook in WPS Office Spreadsheet and identify whether you need a one-time print setting or a reusable setting for new workbooks. For reusable page setup, prepare a blank workbook that can be saved as a template.
Set Fit Sheet on One Page from Page Layout
Use this solution for a one-time print job or when you need to adjust the current worksheet or selected sheets.
Fit to One Page scales the entire print range down so all columns fit within one page wide and all rows fit within one page tall. For large sheets, this may reduce text size, so use Print Preview to check readability.
In WPS Office Spreadsheet, open the Excel workbook and click the worksheet tab you want to fit on one page. To apply to multiple sheets, hold Ctrl and click each sheet tab.
Click the Page Layout tab in the ribbon, and in the Page Setup group click the small launcher arrow to open the Page Setup dialog.
On the Page tab, select Fit to under Scaling, then set the boxes to 1 page(s) wide by 1 page(s) tall.
Click OK, press Ctrl+P to open Print Preview, and verify the output fits one page before printing.
Save the Fit Sheet on One Page Setup as a Template
Use this solution when the same fit-to-one-page page setup should be available for new workbooks or worksheets.
Easily Fit Excel Sheets to One Page in WPS Office
WPS Office Spreadsheet gives you the same Fit Sheet on One Page page setup and print scaling controls as Excel. Set the scale in Page Setup, save it as a template when needed, and print with confidence.
- 1. Open the Excel file: Launch WPS Office Spreadsheet and open the Excel .xlsx workbook that needs fit-to-one-page printing.
- 2. Open Page Layout settings: Select the worksheet, click the Page Layout tab, and open Page Setup.
- 3. Set scaling to Fit to 1 page: In the Page tab, choose Fit to and set 1 page wide by 1 page tall, then click OK.
- 4. Preview and print: Press Ctrl+P, check the one-page preview, and click Print.
Frequently Asked Questions
How do I make an Excel worksheet print on one page in WPS Office?
Open the worksheet in WPS Office Spreadsheet, click Page Layout > Page Setup > Page tab, choose Fit to under Scaling, set 1 page wide by 1 page tall, click OK, then press Ctrl+P to preview and print.
Can I make Fit Sheet on One Page the default for all new workbooks?
Yes. Set up the page setup in a blank workbook, save it as a WPS Spreadsheet Template (.et) or Excel Template (.xltx), then create new workbooks from that template under Menu > New > Personal.
Why does Fit to One Page make my printed text very small?
Fit to One Page scales the entire printed range to fit one page. If the sheet has many columns or rows, WPS Office reduces the scale, so the text may appear small. Try landscape orientation, reduce margins, hide non-essential columns, or define a print area before applying Fit to One Page.
How do I fit every sheet in a workbook to one page before printing?
Hold Ctrl and select all sheet tabs, open Page Layout > Page Setup, set Fit to 1 page wide by 1 page tall, click OK, then press Ctrl+P and choose Entire Workbook in the print range before printing.
Does WPS Office support Excel .xlsx files for fit-to-one-page printing?
Yes, WPS Office Spreadsheet opens and saves .xlsx files and keeps page setup and scaling settings, so you can apply Fit to One Page to Excel workbooks.
