Excel Performance Problems

How to Remove Thousands of Empty Rows or Worksheets in Excel with WPS Office

Elise WilliamsElise Williams Nov 13, 2026 870 views

Question details

The user needs to identify and delete extra worksheets or an inflated used range in an Excel workbook so it no longer shows thousands of empty pages, rows, columns, or sheet tabs.

Remove Thousands of Empty Rows or Worksheets in Excel with WPS Office
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
An Excel workbook appears to contain thousands of empty pages, rows, columns, or worksheets even though the actual data occupies only one area.
Observed behavior
The workbook scrolls far beyond the actual data, shows excessive blank pages in print preview, or contains many blank sheet tabs.
Before you start

Open the workbook in WPS Office Spreadsheets and check the sheet tabs, vertical scroll bar, and horizontal scroll bar to determine whether the extra area comes from unused worksheets, excess rows, or excess columns.

Solution 1

Delete Extra Blank Worksheets

Use this first if the workbook contains many blank sheet tabs or grouped sheets that inflate the page count.

1
Open the workbook in WPS Office Spreadsheets

Launch WPS Office Spreadsheets, click Menu > Open, and open the affected Excel workbook.

2
Delete a single blank worksheet

Right-click the blank sheet tab at the bottom of the window and choose Delete.

3
Delete multiple blank worksheets at once

Press and hold Shift, click the first blank sheet tab and the last blank sheet tab to select them all, right-click the selected tabs, and choose Delete.

WPS Office Spreadsheets

Clean Up Excel Workbooks by Removing Empty Rows and Worksheets in WPS Office

WPS Office Spreadsheets lets you delete extra blank worksheets and clear the inflated used range directly in the Excel file, then save and reopen it so scrolling, printing, and file size return to the actual data area.

  1. 1. Open the Excel file: Launch WPS Office Spreadsheets, click Menu > Open, and open the affected Microsoft Excel workbook.
  2. 2. Delete unused worksheets: Right-click the blank sheet tabs at the bottom and choose Delete, or hold Shift and select multiple blank tabs to delete them together.
  3. 3. Delete excess rows and columns: Click the first empty row below your data, press Ctrl+Shift+Down Arrow, right-click the row header and choose Delete. Repeat for columns using Ctrl+Shift+Right Arrow.
  4. 4. Save under a new name and reopen: Click Menu > Save As, save the workbook under a new name, close it, and reopen it so WPS Office recalculates the used range.
Removes blank sheet tabs and resets the visible scroll range without touching your real dataFully supports .xlsx, .xls, and .csv files from Microsoft OfficeLightweight and fast even on large workbooksFamiliar ribbon and right-click sheet controls for easy cleanup
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel workbook show thousands of empty pages even though I only filled one area?

This usually happens because the workbook contains extra blank worksheets or the used range extends far beyond the actual data. In WPS Office Spreadsheets, delete unused sheet tabs and excess rows or columns, then save the file under a new name and reopen it.

How do I delete many blank worksheets at once in WPS Office Spreadsheets?

Press and hold Shift, click the first blank sheet tab and the last blank sheet tab to select them all, right-click the selected tabs, and choose Delete. Keep only the worksheet tabs that contain real data.

Why does the scroll bar still go down thousands of rows after I delete rows and columns?

The used range is recalculated when the workbook is saved and reopened. Click Menu > Save As, save the workbook under a new name, close it, and reopen it in WPS Office Spreadsheets to reset the scroll range.

Can I remove excess cell formatting instead of deleting rows and columns?

Microsoft 365 has a Clean Excess Cell Formatting feature for some enterprise plans. In WPS Office, the reliable method is selecting and deleting the blank rows and columns beyond the data, then saving and reopening the workbook.