Why an Excel Workbook File Size Increases and How to Reduce It
Question details
The user wants to understand why an Excel workbook has grown dramatically and how to reduce its file size.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook has grown from kilobytes to megabytes after content or formatting was added.
- Observed behavior
- The saved workbook is much larger than expected; excess formatting, unused ranges, images, objects, formulas, or cached data may be contributing.
Check the workbook's current size in its file properties and identify whether it is an XLSX or macro-enabled XLSM file. Make a working copy so you can compare its size after each cleanup.
Remove Excess Formatting and Unused Ranges in Excel
Use this method when a worksheet's used range extends far beyond its actual data.
Open the working copy in Excel. On each worksheet, press Ctrl+End to jump to the last cell Excel considers used.
If Ctrl+End lands well beyond the data, check the intervening rows and columns for formulas, formatting, or content you still need.
Select the row headers below your data or the column headers to its right, excluding anything you need. Right-click the selected headers and choose Delete.
Use File > Save, close the workbook, and reopen it. Check its file properties and repeat Ctrl+End to see whether the used range and file size have decreased.

Review Images, Objects, PivotTable Caches, and Macros
Use this method if cleaning unused ranges does not explain the workbook's size.
Reduce Workbook Clutter in WPS Spreadsheet
Open a copy in WPS Spreadsheet to inspect unused rows and columns, remove unnecessary content, and save a cleaned workbook for a size comparison.
- 1. Open a workbook copy: In WPS Spreadsheet, choose Open and select a copy of the workbook.
- 2. Inspect unused areas: Select each worksheet tab and review the rows and columns beyond the data for formatting or content you no longer need.
- 3. Delete excess ranges: Select unused row or column headers, right-click, and choose Delete. Review each selection first to avoid removing needed data.
- 4. Save and compare: Choose Menu > Save As and save an XLSX copy if macros are not needed. Close the file and compare its size with the original in file properties.

Frequently Asked Questions
Why is my Excel file large even though it has little data?
Formatting applied far beyond the data, images, embedded objects, or PivotTable caches can add to the file size. Press Ctrl+End on each sheet and check Home > Find & Select > Selection Pane for objects.
Will deleting blank cells reduce the workbook size?
It can help if those cells carry excess formatting or extend the used range. Select unused row or column headers, right-click and choose Delete, then save, close, and reopen the workbook before checking its size.
Should I save my workbook as XLSX or XLSM?
Use File > Save As and choose XLSM if you need to retain macros. Choose XLSX only when the macro code is not needed, because XLSX cannot store VBA macros.
Can a PivotTable make an Excel workbook larger?
Yes. A PivotTable can store cached source data in the file. Right-click the PivotTable, choose PivotTable Options > Data, and review whether you need to save the source data with the file.




