Others

How to Reduce the Number of Rows in an Excel Worksheet

Rana Garcia Oct 21, 2026 868 views

Question details

The user wants to know if it is possible to reduce the default 1,048,576 row count in a modern Excel worksheet to make navigating the document easier.

How to Reduce the Number of Rows in an Excel Worksheet

Product: Microsoft Excel
Device & OS: not provided
Scenario: Navigating a large worksheet containing millions of unnecessary empty rows.
Observed behavior: Modern Excel worksheets always display up to 1,048,576 rows, and manually deleting rows does not permanently decrease this maximum row count.

Before you start

Before attempting to reduce your row count by changing file formats, ensure you evaluate your spreadsheet for any modern Excel features, as legacy formats may not support them.

Solution 1Recommended

Save the Workbook in the Older .xls Format

Converting your modern .xlsx workbook to the legacy .xls format physically reduces the strict row limit from 1,048,576 down to 65,536.

Since Excel 2007, the default row limit is fixed at over a million rows and cannot be permanently changed within the modern workbook format. By downgrading the file type, you force the application to respect the older, smaller grid size.

Open Save As menu

Click on the 'File' tab in the top-left corner of your Excel window, then select 'Save As' from the left-hand menu.

Select the legacy format

Click on the 'Save as type' drop-down menu and choose 'Excel 97-2003 Workbook (*.xls)' from the list of available formats.

Save the file

Choose your desired save location, enter a file name, and click the 'Save' button to apply the new 65,536 row limit.

Save the Workbook in the Older .xls Format

Feature Compatibility Warning: Saving your file in the older .xls format may remove or disable newer Excel functionality, custom formatting, and formulas introduced after Excel 2007.

Solution 2

Delete Unwanted Row Contents

While you cannot alter the 1,048,576 row limit in modern formats, you can clear unwanted data and delete rows to keep your workspace organized.

Efficient Spreadsheet Management

Easily Manage Massive Worksheets with WPS Spreadsheet

While modern spreadsheet software enforces a strict 1-million-row limit, WPS Spreadsheet offers an incredibly lightweight and intuitive alternative to manage massive datasets without lagging. You can easily hide blank rows, clear unnecessary data, or save in legacy formats seamlessly.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing .xlsx or .xls spreadsheet.
2. Select the empty rows: Click the first empty row number, then press 'Ctrl + Shift + Down Arrow' to highlight all remaining empty rows to the bottom.
3. Hide the rows for better navigation: Right-click the selected row headers and choose 'Hide' to visually reduce your worksheet without altering the file format.
4. Save the file: Click 'Save' to preserve your new, cleanly organized worksheet view.

Free and lightweight alternative to heavy office suitesFully compatible with Microsoft Excel formats (.xlsx and .xls)Intuitive right-click menus to quickly hide or delete excess rowsFamiliar user interface ensuring a zero-learning-curve transition

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel worksheet always show 1,048,576 rows?

Starting from Excel 2007, Microsoft expanded the maximum worksheet grid to 1,048,576 rows to accommodate larger modern datasets. This is a hardcoded default limit for all .xlsx workbooks and cannot be permanently decreased within that format.

Will deleting empty rows permanently reduce the total row count?

No. Selecting and deleting rows will only clear their contents and formatting. The application will instantly replace the deleted rows with fresh blank rows at the very bottom, maintaining the strict 1,048,576 total.

Is there a way to visually remove empty rows without changing file formats?

Yes. Instead of changing to a legacy format, you can select the row headers of all the unused rows, right-click, and select 'Hide'. This removes them from your immediate view and significantly improves worksheet navigation.

Office Quick Solutions