Reduce Excel File Size Caused by Unused Rows and Columns
Question details
Reduce an Excel workbook's size and improve performance when unused rows contain formulas or formatting.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet has formulas extending beyond its actual data, and the user wants to reduce the workbook's size without losing needed content.
- Observed behavior
- Excel displays a large fixed worksheet grid, while formulas and formatting in unused cells can increase file size and slow calculations.
Identify the last row and column containing needed data on each affected sheet, including formulas or notes outside the main table. Press Ctrl+End to check Excel's last used cell and compare it with the actual data boundary.
Delete Unused Worksheet Rows and Columns
Remove excess formulas and formatting beyond the real data, then save and reopen the workbook to check the used range.
Excel's worksheet grid cannot be permanently cropped. Deleting unused rows and columns removes their contents and formatting, but the worksheet retains its fixed grid dimensions.
On the affected worksheet, click the row header immediately below the last row you need, then press Ctrl+Shift+Down Arrow to select the remaining rows.
On the Home tab, open Delete and choose Delete Sheet Rows. Do not use the Delete key alone, because it clears contents without necessarily removing formatting.
Click the column header immediately to the right of the last column you need, press Ctrl+Shift+Right Arrow, then choose Home > Delete > Delete Sheet Columns.
Select File > Save, close and reopen the workbook, then press Ctrl+End on the sheet to check its used range. Repeat the cleanup on other affected sheets.

Limit Formulas to Rows That Contain Data
Prevent unnecessary calculations and file growth by replacing formulas filled far beyond the data with bounded ranges or table references.
Clean Up Unused Rows and Columns in WPS Spreadsheet
Open the workbook in WPS Spreadsheet, remove unused rows and columns, and limit formulas to the data you need before saving the file.
- 1. Open the workbook: Open WPS Spreadsheet and choose Open to select the Excel workbook.
- 2. Delete unused rows: Select the row headers below the last needed data row, right-click the selection, and choose Delete.
- 3. Delete unused columns: Select the column headers to the right of the last needed data column, right-click the selection, and choose Delete.
- 4. Limit formulas and save: Use the formula bar to replace unnecessarily broad references with ranges that cover your data, then choose File > Save As and save the workbook in XLSX format.

Frequently Asked Questions
Can I permanently remove the blank grid from an Excel worksheet?
No. Excel worksheets have fixed maximum dimensions. You can delete unused rows and columns to remove excess contents and formatting, but the grid remains.
How can I tell whether Excel considers distant cells used?
On the worksheet, press Ctrl+End. If Excel moves far beyond your actual data, excess formatting or contents may be extending the used range.
Why is my workbook still large after I clear unused cells?
The Delete key clears contents but may leave formatting. Try selecting unused row or column headers and choosing Home > Delete > Delete Sheet Rows or Delete Sheet Columns, then save and reopen the workbook.
How can I avoid filling formulas into thousands of empty rows?
Use a limited range in the formula bar, or select your data and choose Insert > Table. Table formulas and structured references can expand as you add data.




