Excel Max Row Limit: Rows, Columns, and Workarounds

In Microsoft Excel for Microsoft 365, a worksheet can contain a maximum of 1,048,576 rows. That limit applies to each worksheet, not to the entire workbook; adding another sheet gives you another grid, but it does not make any one sheet longer.

The exact worksheet limit

Excel numbers worksheet rows from 1 through 1,048,576. The first row is available for a title or column headings, and the final row is a normal worksheet row: it can contain values, formulas, or formatting. There is no setting that increases the row count beyond that boundary in current desktop Excel.

A worksheet also has a maximum of 16,384 columns, ending at column XFD. These limits define the size of the grid; they do not mean that every cell is filled or that Excel can comfortably calculate a very large workbook. In practice, memory, formulas, formatting, and the size of the data can make a workbook slow well before it reaches the final row.

The same row ceiling applies to Excel for the web and current Excel for Mac. The interface may look different across platforms, but switching from Windows to Mac or opening a workbook in a browser does not provide a larger worksheet.

How many data records fit?

The maximum number of records depends on how your sheet is arranged. If row 1 contains field names such as Date, Customer, and Amount, the sheet has room for 1,048,575 data rows beneath that header. If you use two rows for a title and headers, the available data-row count is 1,048,574.

Blank rows count as part of the grid just like populated rows, but they do not reduce the number of rows available below them unless they occupy positions before your data. For example, a list starting in row 10 can still extend to row 1,048,576, but it has only 1,048,567 row positions from its starting point through the bottom. This distinction matters when estimating whether a sheet can hold an export.

For a dataset split across several sheets, each sheet has its own row ceiling. That can be useful for separate periods or categories, but splitting a single table across sheets can make sorting, filtering, formulas, and analysis less convenient. It is often better to keep the full source data in a database or data model and bring a suitable summary into a worksheet.

Why older Excel files have a smaller limit

Excel’s row capacity depends partly on the file format. The older Excel 97–2003 workbook format, usually saved with the .xls extension, supports 65,536 rows and 256 columns, with the last column labeled IV. Modern Excel workbook formats such as .xlsx and .xlsm support 1,048,576 rows and 16,384 columns.

This difference can cause trouble when a modern workbook is saved in the older .xls format. Excel may warn that the workbook has features or data that are incompatible with the format. Rows or other content beyond the older format’s capacity cannot be preserved there as ordinary worksheet data. If you need the modern row limit, keep the workbook in a current format such as .xlsx, or .xlsm when it contains macros.

Opening an old .xls workbook in a modern version of Excel does not automatically expand its existing sheet. The workbook may remain in Compatibility Mode, and the older file format still has its own constraints. Saving a copy in .xlsx format allows the file to use the newer grid, but check formulas, formatting, and other legacy features after conversion.

What happens when a sheet reaches the bottom?

You cannot enter or paste ordinary worksheet data into row 1,048,577 because that row does not exist. If a paste operation includes more rows than fit in the destination, Excel cannot put the overflow into extra rows on the same sheet. Import behavior can vary depending on the tool and destination, so check the resulting row count against the original source rather than assuming the whole dataset was loaded.

Excel can also refuse to insert rows before the sheet is visibly full. A common message says that Excel cannot insert new cells because they would push non-empty cells off the end of the worksheet. This can happen when cells near the bottom contain formatting or other content, even if they look blank. Formatting can make Excel treat part of the sheet as used.

To investigate, press Ctrl+End on Windows to go to the cell Excel considers the last used cell. On Mac, the equivalent is Control+End in many keyboard layouts; the shortcut can vary with keyboard settings. This location is a clue, not proof that all cells up to it contain meaningful data. If the used area is much larger than your actual table, remove unwanted content or formatting from the extra rows or columns, save the workbook, close it, and reopen it. Keep a copy first if the affected cells may contain data you need.

Handling data that exceeds the limit

If the source has more than 1,048,576 rows, choose a method that preserves the complete dataset rather than trying to squeeze it into one sheet. The right choice depends on whether you need to inspect individual records, calculate summaries, or share the data with another system.

Use Power Query to shape or summarize the source. In Excel for Windows, select Data > Get Data to connect to a supported file or data source. You can filter, group, and transform data before loading results to a worksheet. A worksheet destination is still limited to 1,048,576 rows, so loading a query to a sheet does not bypass the cap.
Load suitable data to the Data Model. In Windows Excel, Power Query can load data to the workbook Data Model rather than displaying every record on a worksheet. You can then build PivotTables or other summaries from that model. Its practical capacity depends on available memory and the data; it is not an unlimited store.
Use a database for a large record store. A database is designed to store and query data without displaying every record in a spreadsheet grid. Excel can connect to supported databases and retrieve a filtered set or an aggregated result for analysis.
Use a reporting or analytics tool. For recurring analysis of large datasets, a tool such as Power BI may be more appropriate than placing all records in a worksheet. It can connect to data sources and present summaries while the underlying data remains outside the grid.
Split an export only when the workflow supports it. Dividing data into separate files or sheets can work for archiving or independent batches. If you later need one combined analysis, plan how the pieces will be joined and make sure the split does not create missing or duplicated records.

Power Query and Data Model availability differs by Excel platform and version. The Windows steps above are for Microsoft 365 desktop Excel; Mac features and connectors can differ. Regardless of platform, loading a result to a worksheet remains subject to the worksheet row maximum.

Does 64-bit Excel increase the row limit?

No. Both 32-bit and 64-bit editions of current Excel use the same maximum of 1,048,576 rows per worksheet. The distinction is about the resources the application can address, not the dimensions of the grid. A 64-bit version may be better suited to some memory-intensive workbooks, but it does not create additional worksheet rows.

Actual performance depends on more than the Excel edition. Large numbers of formulas, volatile calculations, complex formatting, links to other workbooks, and many PivotTables can all add overhead. A workbook with fewer rows can therefore be slower than a larger but simpler dataset. If a file is becoming difficult to use, reducing unnecessary formatting and calculations or moving raw records to a data model or database may help more than changing the computer’s memory alone.

Common misconceptions about the row cap

Adding worksheets does not extend a single worksheet. A workbook can have multiple sheets, but each one stops at row 1,048,576. The number of sheets is limited by available memory and system resources rather than by a universal small fixed count, but making many sheets is not the same as expanding one grid.

CSV files are not Excel worksheets. A CSV is a text file format and is not defined by Excel’s worksheet grid. It may contain more records than Excel can display in one sheet. When you open or import such a file into Excel, however, the worksheet ceiling still applies. Do not use an Excel worksheet save as a way to preserve source data that exceeds the grid; retain the original file or use an appropriate data store.

A blank-looking cell may still affect the used area. Formatting, comments, or other cell content can make a distant row appear used to Excel. This can lead to oversized files or insertion warnings, but it does not mean that the sheet has gained extra rows. Conversely, pressing Ctrl+End and seeing a distant cell does not mean all intervening rows contain records.

Frequently Asked Questions

What is the maximum number of rows in Excel 365?

Excel for Microsoft 365 allows 1,048,576 rows on each worksheet. The limit is the same in current Excel for Windows, Mac, and the web. There is no option to raise it.

How many rows can I use if my first row is a header?

You can use 1,048,575 rows for records if the header occupies row 1. If you reserve additional rows for titles or notes above the data, subtract those rows from the space available for records.

Can Excel have more than 1,048,576 rows?

Not on a single worksheet. You can distribute records among sheets, but for one dataset that exceeds the limit, a database, Power Query with the Data Model, or an analytics tool is usually more practical than manual sheet-splitting.

Does opening a CSV with more than a million rows keep every record?

A CSV can contain more records than an Excel sheet can hold, but a worksheet cannot display them all. Importing through Power Query and loading to a Data Model may suit some workflows; otherwise, keep the CSV intact and use a database or another tool that supports the full dataset. Verify the number of imported records.

Why does Excel say it cannot insert rows when the sheet looks empty?

Cells near the bottom of the worksheet may contain formatting or other content that Excel treats as used. Check the last-used-cell location with Ctrl+End on Windows, then inspect and clear genuinely unnecessary content or formatting. Save a backup before clearing anything, since the affected cells might contain information you need.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.