Fix Excel Page Formatting Changes on Different Computers with WPS Office
Question details
The user needs an Excel workbook configured to print on one page to keep the same column formatting and page count when opened on different Windows 11 computers.

- Product
- Microsoft Excel 2021 / WPS Office Spreadsheets
- Device & OS
- Windows 11
- Scenario
- An Excel workbook formatted to print on one page changes column formatting and prints on two pages when opened on another computer, even though both computers use Windows 11 and Excel 2021.
- Observed behavior
- On another Windows 11 computer with Excel 2021, the same workbook changes column formatting and prints across two pages.
Open the affected workbook in WPS Office Spreadsheets and confirm that both computers use the same default printer driver before changing page setup settings.
Standardize printer driver and page setup settings
Use this first when the same workbook prints differently on two computers that have the same Excel version.
Excel and WPS Office rely on the active printer driver for font spacing, line breaks, and printable area. Two computers can show different print layouts when the default printer or driver version differs.
Launch WPS Office, click Menu > Open, and select the Excel workbook that prints differently.
Click File > Print and check the selected printer. Ensure both computers use the same printer model and driver.
Go to Page Layout > Scale to Fit, set Width to 1 page and Height to 1 page.
Click Page Layout > Page Setup, then confirm Paper size, Orientation, and Margins are identical on both computers.
Select File > Print Preview and confirm the entire worksheet fits on one page before printing.

Use lower scaling as a fallback compatibility setting
Use this when the worksheet still spills to two pages after matching printers and page setup.
Fix Excel Page Layout in WPS Office Spreadsheets
Open the affected Excel file in WPS Office Spreadsheets, use Scale to Fit and Page Setup to lock the print layout to one page, and preview before printing.
- 1. Open the Excel workbook in WPS Office: Launch WPS Office, click Menu > Open, and select the workbook that prints differently.
- 2. Set Fit to One Page scaling: Go to Page Layout > Scale to Fit, set Width to 1 page and Height to 1 page.
- 3. Match page setup settings: Click Page Layout > Page Setup and set the same paper size, margins, and orientation as the other computer.
- 4. Check the active printer: Click File > Print, and select the same default printer and driver available on both computers.
- 5. Preview and print: Click File > Print Preview, confirm one page, then click Print.

Frequently Asked Questions
Why does the same Excel file print on two pages on another Windows 11 computer?
The active printer driver changes character spacing, line breaks, and printable area. Open the file in WPS Office Spreadsheets, go to Page Layout > Scale to Fit, and set Width and Height to 1 page.
How do I force an Excel workbook to print on one page in WPS Office?
In WPS Office Spreadsheets, click Page Layout > Scale to Fit, set Width to 1 page and Height to 1 page, then use File > Print Preview to confirm.
Does the printer driver really affect Excel page formatting?
Yes. The printer driver supplies font metrics and printable area information, so different drivers can change where columns and page breaks fall. Use the same default printer driver and version on both computers.
Where can I compare scaling, margins, and paper size in WPS Office?
Click Page Layout > Page Setup in WPS Office Spreadsheets. The Page tab shows paper size, orientation, and scaling, while the Margins tab shows margin values.
Can I prevent print layout changes when sending workbooks to another computer?
Set Fit to One Page scaling, save the workbook, and on the receiving computer open it in WPS Office. Then confirm the same default printer driver is selected before printing.




