Excel Performance Problems

Why an Excel File Remains Large After Deleting Worksheets

Steven ParkerSteven Parker Nov 18, 2026 869 views

Question details

The user wants to understand why an Excel workbook remains large after worksheets are deleted and how to reduce its size.

Why an Excel File Remains Large After Deleting Worksheets
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user has deleted worksheets from a workbook but wants to remove other content that may be keeping the file large.
Observed behavior
The workbook remains large despite the worksheet deletions.
Before you start

Save a copy of the workbook and identify the rows, columns, and sheets that contain data you need. Check whether the file contains macros before saving it in a different format.

Solution 1Recommended

Remove Unused Rows and Columns from Remaining Sheets

Use this method when formatting or other content has extended a sheet's used range far beyond its actual data.

1
Find the used range

On each remaining worksheet in desktop Excel, press Ctrl+End on Windows to go to the last cell Excel considers used. Compare its location with the last row and column containing data you need.

2
Delete excess rows

Select the row headers below the last needed row through the bottom of the sheet, right-click the selection, and choose Delete. Do this only after confirming those rows contain no needed data.

3
Delete excess columns

Select the column headers to the right of the last needed column through column XFD, right-click the selection, and choose Delete. Check that the selected columns contain no needed data first.

4
Save and recheck

Choose File > Save, close the workbook, and reopen it. Press Ctrl+End again on the cleaned sheets and compare the saved file size.

Remove Unused Rows and Columns from Remaining Sheets
Used-range results can vary: Ctrl+End can point beyond visible data because of formatting or other content. Deleting excess rows and columns may reduce file size, but it will not remove every possible source of workbook bloat.
Clean up your workbook with WPS

Reduce Unused Worksheet Content in WPS Spreadsheets

Open the workbook in WPS Spreadsheets, remove unnecessary rows and columns, and save a new copy. This can help when an inflated used range contributes to a large file.

  1. 1. Open the workbook: Launch WPS Spreadsheets and use Open to select the Excel workbook.
  2. 2. Check the used range: On each remaining sheet, review the data boundaries. In WPS Spreadsheets for Windows, press Ctrl+End to check whether the used range extends beyond your data.
  3. 3. Delete unused rows and columns: Select unneeded row or column headers beyond your data, right-click, and choose Delete. Confirm the selection contains no data you need.
  4. 4. Save a new copy: Choose File > Save As, select an Excel .xlsx format, and save the copy. Close and reopen it, then compare its file size with the original.
Remove unnecessary rows and columns from remaining worksheetsOpen and save Microsoft Excel .xlsx workbooksReview workbook data in a familiar spreadsheet interfaceUse WPS Office for free
QA img-9

Frequently Asked Questions

Why does Ctrl+End go far beyond my Excel data?

Formatting or other content in distant cells can extend the used range. Check those rows and columns, delete any that are unnecessary, then save and reopen the workbook.

Can hidden worksheets keep an Excel file large?

Yes. Hidden worksheets remain in the workbook. Right-click a sheet tab and choose Unhide if available, then review the sheets before deleting anything.

Can PivotTables increase workbook size after sheets are deleted?

Yes. Pivot caches can retain source data and contribute to file size. Review remaining PivotTables and their source data before changing or removing them.

Will saving as XLSX always make the workbook smaller?

No. File > Save As can create a new XLSX copy and may remove some legacy content, but the result depends on what remains in the workbook. XLSX does not retain VBA macros.