Excel Performance Problems

Reduce Excel File Size Caused by Unused Rows and Columns

Steve KSteve K Nov 18, 2026 870 views

Question details

Reduce an Excel workbook's size and improve performance when unused rows contain formulas or formatting.

Reduce Excel File Size Caused by Unused Rows and Columns
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.
Before you start

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.

Solution 1Recommended

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.

1
Select unused rows

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.

2
Delete the 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.

3
Delete unused columns

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.

4
Save and check

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.

Delete Unused Worksheet Rows and Columns
Check before deleting: Deleting entire rows or columns also removes any needed content in them. Review the selection first, and check formulas and references after the cleanup.
Reduce spreadsheet file size

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. 1. Open the workbook: Open WPS Spreadsheet and choose Open to select the Excel workbook.
  2. 2. Delete unused rows: Select the row headers below the last needed data row, right-click the selection, and choose Delete.
  3. 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. 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.
Remove excess rows and columns containing unnecessary formulas or formattingOpen and save Microsoft Excel XLSX filesEdit formulas in a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

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.