How to Clear or Edit the Print Area in WPS Office Spreadsheets
Question details
The user needs to clear an existing spreadsheet print area or replace it with a different range through Page Layout settings.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A spreadsheet has an existing print area that no longer matches the intended output, or the user wants to define a new print range before printing.
- Observed behavior
- The current print area still prints the old cell range, causing unwanted pages or missing data.
Open the target workbook in WPS Office Spreadsheets and activate the worksheet that contains the print area. If you plan to set a new print area, decide which cell range should appear in printouts.
Clear the Current Print Area in WPS Office Spreadsheets
Use this solution when you want to remove the saved print range so the entire worksheet can print normally.
In WPS Office Spreadsheets, open your workbook and click the worksheet that has the print area. Then go to the Page Layout tab on the ribbon.
Click Print Area in the Page Setup group, then select Clear Print Area. WPS Office removes the active print area immediately.
Set a New Print Area or Edit the Existing Range
Use this solution when you need to replace the current print area with another cell range or adjust it manually.
Adjust Print Areas Easily in WPS Office Spreadsheets
Use the Page Layout tab in WPS Office Spreadsheets to clear, set, or edit the print area so your spreadsheet prints exactly the range you need.
- 1. Open the workbook: Launch WPS Office Spreadsheets and open the workbook that contains the print area.
- 2. Select or clear the range: Select the cells you want to print, or go to Page Layout > Print Area > Clear Print Area to remove an existing range.
- 3. Apply the print area: Choose Page Layout > Print Area > Set Print Area to save the selected range.
- 4. Check before printing: Go to File > Print to preview the output and confirm only the intended pages appear.
Frequently Asked Questions
How do I clear only a print area without deleting cell data?
Go to Page Layout > Print Area > Clear Print Area in WPS Office Spreadsheets. This removes the print range but leaves all cell contents and formatting unchanged.
Can I print multiple separate ranges as one print area?
Yes. Hold Ctrl while selecting non-adjacent ranges, then go to Page Layout > Print Area > Set Print Area. WPS Office treats the selected ranges as separate print areas.
Why is my spreadsheet printing too many blank pages after setting a print area?
Extra blank pages usually come from an incorrect print range, hidden rows or columns, or leftover formatting outside the intended area. Check Page Setup > Sheet > Print area and adjust the range manually.
How can I see the current print area before printing?
Open the workbook in WPS Office Spreadsheets, go to the View tab, and switch to Page Break Preview. You can also choose File > Print to preview the printed pages.
Does this print area setting work with Excel files?
Yes. WPS Office Spreadsheets opens and saves Excel .xlsx files while preserving print area settings, so the print range can be maintained when moving between Excel and WPS Office.
