Reduce Excel File Size by Clearing Excess Cell Formatting
Question details
Reduce an unexpectedly large Excel workbook by removing unnecessary formatting from unused worksheet areas.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Tables have been converted to ranges, and the user wants to remove formatting left in unused cells.
- Observed behavior
- The workbook is unexpectedly large and may contain excess cell formatting outside the needed data.
Check each worksheet for data, formulas, or formatting you still need beyond the visible table before selecting unused areas. Save a copy of the workbook so you can restore anything removed during cleanup.
Clear or delete unused worksheet areas
Use this method in Excel to remove formatting from areas you have confirmed are no longer needed.
Open the workbook in Excel and inspect the rows below and columns to the right of the required data on each affected worksheet.
Select only cells, rows, or columns that contain no data, formulas, or formatting you need to keep.
Choose Home > Clear > Clear All, or right-click the selected row or column headers and choose Delete. Clear All also removes cell contents, so check the selection first.
Choose File > Save, close and reopen the workbook, and check its file size. Repeat the cleanup on other affected sheets if necessary.

Optimize workbook performance in Excel for the web
Use Check Performance when it is available in Excel for the web to identify and optimize cells with excess formatting.
Clean excess cell formatting with the Excel Inquire add-in
Use this option if your Excel edition includes the Inquire add-in.
Clean Unused Worksheet Areas in WPS Spreadsheet
Open the workbook in WPS Spreadsheet and clear unused cells or delete unneeded rows and columns to remove excess formatting. Save the result as a new Excel workbook and check whether its size has decreased.
- 1. Open the workbook: In WPS Office, open the Excel workbook in WPS Spreadsheet.
- 2. Select unused areas: On each affected sheet, select cells or row and column headers outside the data and formulas you need to keep.
- 3. Clear or delete: Choose Home > Clear > Clear All, or right-click selected row or column headers and choose Delete. Clear All also removes cell contents.
- 4. Save and compare: Choose File > Save As and save a new XLSX copy. Close the workbook and compare its file size with the original.

Frequently Asked Questions
Why is my Excel file large after converting a table to a range?
Converting a table to a range can leave formatting in place, and other unused cells may also retain styles. Inspect the affected sheet and clear only areas you no longer need.
Does Clear All remove data as well as formatting?
Yes. Home > Clear > Clear All removes cell contents and formatting, so select only cells you have confirmed are unused.
Where is Check Performance in Excel for the web?
Open the workbook in Excel for the web and look for Review > Check Performance. Availability can depend on your account and workbook.
What if Inquire is missing from Excel?
Check File > Options > Add-ins, select COM Add-ins under Manage, and choose Go. If Inquire is not listed, your Excel edition may not include it; use manual cleanup or Excel for the web instead.
Why did the file size stay large after cleanup?
Excess formatting may not be the only cause. Save and reopen the workbook, check other sheets for unused areas, or copy the needed worksheets into a new workbook and compare the saved file sizes.




