How to Remove Blank Pages from an Excel Worksheet Before Printing in WPS Office
Question details
The user needs to stop an Excel worksheet from printing two blank pages at the end and to preview the page layout before printing.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A worksheet contains five pages of data, but the printout produces seven pages because two empty pages are included at the end.
- Observed behavior
- The worksheet prints seven pages with two blank pages at the end.
Open the workbook in WPS Office Spreadsheets and switch to Page Break Preview to see where the automatic page breaks are placed before deleting anything.
Delete Unused Columns and Rows in Page Break Preview
Use this solution when you want to permanently remove blank pages caused by empty rows or columns beyond the data area.
In WPS Office Spreadsheets, click the View menu and select Page Break Preview from the Workbook Views group.
Look at the blue page break lines and identify the empty pages after the last column or row that contains data.
Click the first blank column header to the right of your data, press Ctrl+Shift+Right Arrow to select all unused columns, right-click the selection, and choose Delete.
Click the first blank row number below your data, press Ctrl+Shift+Down Arrow to select all unused rows, right-click the selection, and choose Delete.
Press Ctrl+P to open Print Preview, verify that the page count is five pages, and then click Print.
Print Only the Selected Data Range
Use this solution when you do not want to modify the worksheet structure and only need a quick print of the data that matters.
Fit the Worksheet to a Specific Number of Pages
Use this solution when blank pages are caused by extra columns or rows that overflow the print area and scaling can adjust the output.
Remove Blank Pages Before Printing in WPS Office Spreadsheets
WPS Office Spreadsheets lets you inspect page breaks, delete unused rows and columns, and use Print Selection or fit-to-page controls so only the pages you need are printed. It opens Excel files directly and provides the same familiar worksheet printing workflow.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office, open the Excel-compatible workbook, and click the View menu.
- 2. Switch to Page Break Preview: Select Page Break Preview to display blue page boundary lines and see the blank pages at the end.
- 3. Delete unused rows and columns: Select the empty columns and rows beyond your data, right-click the selection, and choose Delete.
- 4. Choose Print Selection or fit-to-page: Press Ctrl+P, select Print Selection or open Page Layout > Page Setup and choose Fit to, then check that the preview shows five pages.
- 5. Print the worksheet: Click Print to output only the pages you need.
Frequently Asked Questions
Why is my Excel worksheet printing extra blank pages at the end?
Extra blank pages usually appear because WPS Office Spreadsheets detects formatting, stray content, or unused rows and columns beyond your data area. Switch to View > Page Break Preview to see the page boundaries, then delete those extra rows and columns.
How do I preview exactly how many pages will print in WPS Spreadsheets?
Open the View menu and choose Page Break Preview, or press Ctrl+P to open Print Preview. The preview shows the page count before you print.
Can I print only selected cells instead of deleting blank pages?
Yes. Select the cells you want to print, press Ctrl+P, and choose Print Selection in the print range settings. This skips empty columns and rows without changing the worksheet.
How do I use fit-to-page scaling to remove blank pages in WPS Spreadsheets?
Go to Page Layout > Page Setup, choose Fit to under Scaling, and set the output to the number of pages wide and tall you want. Then check the Print Preview page count.
Does deleting unused rows and columns affect my data?
Deleting rows and columns beyond the data area does not affect the cells you are keeping, but check the blue page break boundaries first so you do not remove any needed cells.
