Excel Performance Problems

Why an Excel Workbook File Size Increases and How to Reduce It

Steven ParkerSteven Parker Nov 20, 2026 869 views

Question details

The user wants to understand why an Excel workbook has grown dramatically and how to reduce its file size.

Why an Excel Workbook File Size Increases and How to Reduce It
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.
Before you start

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.

Solution 1Recommended

Remove Excess Formatting and Unused Ranges in Excel

Use this method when a worksheet's used range extends far beyond its actual data.

1
Check the used range

Open the working copy in Excel. On each worksheet, press Ctrl+End to jump to the last cell Excel considers used.

2
Inspect the extra area

If Ctrl+End lands well beyond the data, check the intervening rows and columns for formulas, formatting, or content you still need.

3
Delete unused rows and columns

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.

4
Save and compare

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.

Remove Excess Formatting and Unused Ranges in Excel
Check before deleting: Hidden rows, columns, formulas, and intentionally formatted areas may be important. Review them before deleting any range.
Clean up a workbook with WPS Spreadsheet

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. 1. Open a workbook copy: In WPS Spreadsheet, choose Open and select a copy of the workbook.
  2. 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. 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. 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.
Remove unused rows and columns that can contribute to workbook bloatOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceEdit workbooks with a free, lightweight office suite
microsoft office alternative - wps office

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.