Why an Excel File Remains Large After Deleting Worksheets
Question details
The user wants to understand why an Excel workbook remains large after worksheets are deleted and how to reduce its size.

- 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.
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.
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.
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.
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.
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.
Choose File > Save, close the workbook, and reopen it. Press Ctrl+End again on the cleaned sheets and compare the saved file size.

Inspect Workbook Content That May Still Increase File Size
Use these checks if the workbook remains large after you clean the used ranges.
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. Open the workbook: Launch WPS Spreadsheets and use Open to select the Excel workbook.
- 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. 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. 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.

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.




