Excel Row Limit Per Sheet: Maximum Rows Explained

Microsoft Excel supports a maximum of 1,048,576 rows per worksheet, from row 1 through row 1,048,576. That limit applies to modern desktop Excel, including Microsoft 365, and Excel for the web; it is a limit on each sheet, not a fixed row total for an entire workbook.

The Exact Maximum and What It Means

The final row number in a current Excel worksheet is 1,048,576. A sheet cannot be extended beyond it: there is no command or setting that adds another row to the grid. The limit is the same whether the sheet is mostly empty or contains data in every row.

A row is part of the worksheet grid even when its cells are blank. Clearing cell contents does not remove rows or create additional capacity, because the worksheet always has the same fixed dimensions. You can confirm the lower boundary by using the Name Box—the small box to the left of the formula bar—and entering A1048576. Excel will select the first cell in the last row.

Row capacity can matter when planning a dataset. If a table starts in row 1 and has a header in row 1, it can contain at most 1,048,575 data rows beneath that header. If it starts lower down, or has a totals row, fewer rows remain available for records.

Why Excel Has This Limit

The current worksheet dimensions date to Excel 2007, when Microsoft expanded the grid from the older 65,536-row format to 1,048,576 rows. The newer grid has 16 times as many rows and 64 times as many columns as the older one. Modern Excel worksheets have 16,384 columns, ending at column XFD.

The dimensions are built into the worksheet and file formats. They are not simply a preference that can be raised in Excel Options, nor do they depend on how many rows a computer has free in memory. A powerful computer can help Excel process a large workbook, but it cannot make a single worksheet exceed its defined row count.

Rows Per Sheet Versus Rows Per Workbook

The 1,048,576 figure applies to each worksheet individually. A workbook can contain multiple sheets, so it can hold more rows in total by distributing data across sheets. Excel does not provide a single practical row-total limit for an entire workbook in the same way it sets the grid dimensions of one sheet; the number of sheets and the amount of data a workbook can handle depend on available memory and other system resources.

For example, a workbook could keep one year of records on each annual sheet, with each sheet staying within its own row boundary. This may work for a modest project, but splitting data across tabs can make filtering, analysis, and formulas more complicated. A single table is generally easier to sort and summarize as long as it fits, while larger datasets may be better kept in a database or a data model.

Excel Tables do not bypass the worksheet limit. A table can expand automatically as records are added, but it cannot grow below the last worksheet row. If you try to add a record when the table has reached the bottom, you must make room elsewhere or use another storage approach.

What Happens When You Reach the Last Row

When a worksheet has no available rows below a dataset, Excel cannot insert or append more records to that sheet. A paste or import that would extend past the bottom cannot place all of its rows there. Depending on the operation, Excel may show a warning, refuse the action, or leave data outside the worksheet unimported. Do not assume that a successful-looking import means every source record arrived: compare the source record count with the rows loaded.

Before reaching the boundary, check whether blank-looking rows are actually occupied by formulas, formatting, or other content, and whether the dataset includes a header or totals row. Clearing data can free cells for reuse, but it does not increase the sheet’s maximum dimensions. If the records are valid and all are needed, arrange to split or redirect them rather than deleting data simply to make a paste fit.

For a one-time continuation, place the next batch on another sheet and label the batches clearly.
For recurring data, keep source files organized by date or category and combine them with an appropriate query or database workflow.
For analysis across a larger dataset, consider loading the data to Excel’s Data Model or using a database tool instead of trying to display every record in worksheet cells.

Working With Data Larger Than One Sheet

Power Query can import, transform, and combine data from sources such as text files, folders, and databases. In Excel for Microsoft 365 on Windows, use Data > Get Data to start a supported import. Depending on the connection and available options, a query can be loaded to a worksheet, loaded to the Data Model, or kept as a connection. Loading to a worksheet remains subject to the 1,048,576-row limit; the Data Model is a different storage destination and can hold more rows, with practical capacity affected by memory, data shape, and the Excel edition.

Another option is a database, which is designed to store and query records without displaying the entire dataset as a spreadsheet grid. Excel can then retrieve summaries or selected records for analysis. This is often more manageable than spreading millions of records across many tabs, particularly when several people need to update or query the same source.

Splitting a file across worksheets can still be reasonable when the split has a clear meaning, such as one sheet per year, and each sheet stays below the limit. Keep consistent column names and data types, and document the split. Be aware that formulas and reports spanning multiple sheets may require extra maintenance when a new sheet is added.

CSV Imports and Other File Formats

A CSV file is plain text and is not itself a worksheet, but opening or loading it into Excel puts its data into a worksheet with Excel’s row ceiling. A CSV containing more than 1,048,576 rows cannot be displayed in full on one sheet. For a large source file, use an import workflow that lets you choose a destination such as the Data Model, or process the file with a database or another tool built for larger datasets. Check the imported row count and any import messages.

File format matters too. The older Excel 97–2003 workbook format, .xls, supports only 65,536 rows and 256 columns per worksheet. If a modern workbook is saved in that format, Excel may warn that some content is incompatible; data beyond the older format’s limits cannot be preserved there. For current Excel work, use a modern format such as .xlsx or .xlsb when appropriate. These formats do not increase a sheet’s row limit, but they avoid the old .xls grid restriction.

Row Limit Is Not the Same as Performance

Being below the maximum does not guarantee that a workbook will feel fast. A sheet with hundreds of thousands of rows can become slow if it contains many complex formulas, extensive conditional formatting, volatile calculations, or large numbers of shapes and styles. Available memory, processor performance, workbook design, and the number of open files all affect responsiveness.

Likewise, reaching the row limit does not mean the workbook is necessarily corrupted. It means the sheet has no more grid rows available. For better performance, remove unnecessary formatting, avoid duplicating formulas or data, and use filters, PivotTables, or the Data Model to analyze records without creating oversized intermediate ranges. Saving a file in a different format may reduce file size or improve handling in some cases, but it does not add worksheet rows.

How the Limit Differs in Older Excel

Excel 2007 and later use the 1,048,576-row and 16,384-column grid. Excel 2003 and earlier use a maximum of 65,536 rows and 256 columns, with the last column labeled IV. That difference is important when exchanging files with someone using older software or when a workbook is saved as .xls for compatibility.

Excel for Mac and Excel for the web use the same modern worksheet row maximum as current Excel for Windows. Some interface details and available import or data-model features differ by platform and edition, but the row boundary itself does not. If another spreadsheet program or an older Excel version is involved, check that program’s own limits rather than assuming the current Excel dimensions apply.

Frequently Asked Questions

Can I increase the Excel row limit?
No. Excel does not offer a setting to add rows to a worksheet beyond 1,048,576. To store more records, use additional sheets, load data to the Data Model where suitable, or use a database or another data tool.

Does Excel have 1,048,576 rows in every sheet?
Yes. Each modern Excel worksheet has that grid size, whether it contains data or is blank. The number of rows available for records can be lower if headers, totals, or other content use rows.

How many data rows fit if my table has a header?
If the header is in row 1 and there is no totals row, up to 1,048,575 data rows can fit beneath it. A table that starts farther down the sheet has fewer available data rows.

Can a workbook contain more than 1,048,576 rows altogether?
Yes. The maximum is per worksheet, so records can be split across multiple sheets. Total workbook capacity is constrained in practice by memory, performance, and other workbook limits, not by one universal row total.

What is the row limit for an Excel .xls file?
The older .xls format supports 65,536 rows per worksheet. Use .xlsx or .xlsb for modern Excel workbooks, while remembering that those formats still have a 1,048,576-row limit on each sheet.

Can Power Query load more rows than a worksheet?
It can use destinations other than a worksheet, including the Data Model when available. Loading the query output directly to a sheet is still subject to that sheet’s 1,048,576-row limit, and Data Model capacity depends on the system and dataset.

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.