Fix Excel Printing One Page Per Cell in WPS Office Spreadsheet
Question details
User needs to stop a spreadsheet from printing each cell on a separate page when print area, scaling, and page-break settings appear correct.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- The user is printing a worksheet and expects a normal continuous printout, but the output splits into one page per cell.
- Observed behavior
- The spreadsheet prints one page per cell even though print area, scaling, and page-break settings look correct.
Open the workbook in WPS Office Spreadsheet and switch to Page Break Preview to see whether an excessive number of blue page breaks are active. Also confirm that only the intended data range is selected before changing print-area settings.
Reset Page Breaks and Set the Print Area in WPS Office Spreadsheet
Use this when the worksheet prints one page per cell because WPS Office is using unwanted page breaks or a print area that no longer matches the actual data.
Page Break Preview shows every page boundary as blue lines. Resetting all page breaks and setting a clean print area normally resolves the one-page-per-cell behavior without changing the worksheet data.
Double-click the workbook file so it opens in WPS Office Spreadsheet, or click Menu > Open in WPS Spreadsheet.
Click the View tab and select Page Break Preview to reveal all active page breaks.
Go to Page Layout > Breaks > Reset All Page Breaks to remove the excessive breaks.
Select only the cells you want to print, then go to Page Layout > Print Area > Set Print Area.
Press Ctrl+P, confirm the preview shows the data as a normal page or pages, and click Print.
Fit the Worksheet on One Page with Scaling and Page Setup
Use this when the print area is correct but the printed output still spreads content across many pages because scaling, paper size, or orientation is wrong.
If the Behavior Persists in Excel, Test Safe Mode and Repair Microsoft 365
Use this if the issue follows every Microsoft Excel workbook and is caused by an add-in or an Office installation problem rather than the worksheet settings.
Print Normally in WPS Office Spreadsheet Instead of One Page per Cell
Open the affected Excel workbook in WPS Office Spreadsheet, clear unwanted page breaks, set a proper print area, and apply Fit Sheet on One Page to produce a normal printout. WPS Office works directly with .xlsx files and gives you familiar print controls without an Office repair.
- 1. Open the workbook in WPS Spreadsheet: Download WPS Office, launch WPS Spreadsheet, and open the affected .xlsx workbook.
- 2. Reset page breaks and set the print area: Click View > Page Break Preview, go to Page Layout > Breaks > Reset All Page Breaks, select the data range, and click Page Layout > Print Area > Set Print Area.
- 3. Fit the printout on one page: Press Ctrl+P, set the scaling option to Fit Sheet on One Page, and check that paper size and orientation match the worksheet.
- 4. Print and verify: Preview the printout and click Print. Confirm the spreadsheet prints as normal pages instead of one page per cell.
Frequently Asked Questions
Why does Excel print one page per cell even when the print area is correct?
It usually means there are hidden page breaks or the print area is set to a non-contiguous or tiny range. In WPS Spreadsheet, click View > Page Break Preview to see blue page-break lines, then use Page Layout > Breaks > Reset All Page Breaks and set a clean print area.
How do I reset all page breaks in WPS Office Spreadsheet?
Open the workbook, go to Page Layout > Breaks > Reset All Page Breaks, then select the data and click Page Layout > Print Area > Set Print Area.
Can I use WPS Office to print an Excel file that prints one cell per page?
Yes. Open the .xlsx file in WPS Office Spreadsheet, reset page breaks, set the print area, and choose Fit Sheet on One Page in the Print settings.
What should I do if only one workbook prints this way?
The workbook may contain hidden page breaks or corruption. In WPS Spreadsheet, reset all page breaks and print area. In Excel, copy the worksheet to a new workbook and test it in Safe Mode.
Does WPS Office preserve Excel print settings like paper size and scaling?
Yes. WPS Office supports Excel .xlsx files and retains paper size, orientation, margins, print area, and scaling, although page breaks may be updated when the file is opened in another application.
