Microsoft Excel supports a maximum of 1,048,576 rows per worksheet, numbered 1 through 1,048,576. That limit applies to Excel for Microsoft 365 on Windows and to modern Excel versions generally; if a worksheet needs more rows, you must use another sheet or a tool designed for larger datasets.
What the row limit means
The limit is the size of the worksheet grid, not a recommended amount of data. Every worksheet has 1,048,576 row positions, whether they are blank or filled. A worksheet also has 16,384 columns, running from A through XFD. The row and column limits describe the maximum grid; they do not guarantee that a workbook containing data in every cell will be practical to use.
A header row counts as a row. For example, a list with column names in row 1 has room for at most 1,048,575 data records on that sheet, in rows 2 through 1,048,576. Without a header on the sheet, all 1,048,576 rows could contain records. In practice, most datasets reach performance or usability problems well before filling the entire grid.
Excel tables, filters, and formatted ranges do not provide extra rows beyond the worksheet. A table can expand as you add records, but it cannot extend past row 1,048,576. The same is true of formulas, charts, and other worksheet features: they operate within the worksheet’s grid.
Why Excel has a maximum
A spreadsheet needs a defined grid so Excel can address cells, calculate formulas, display data, and save workbook content in a consistent way. Each cell is identified by a row and a column, such as A1 or XFD1048576. The grid’s dimensions therefore set a firm boundary for cells on an individual worksheet.
Excel’s current row capacity dates to the larger worksheet format introduced with Excel 2007. Older versions, including Excel 2003 and earlier, were limited to 65,536 rows and 256 columns per worksheet. This difference still matters when someone shares a workbook in the older .xls format: that format retains the legacy limits. A modern .xlsx workbook can use the larger grid, but saving to an older format can require compatibility changes or leave data beyond the old limit out of the saved worksheet.
The maximum number of rows in a workbook is not simply 1,048,576. That figure applies to each worksheet, and a workbook can contain multiple worksheets. Excel does not set one universal fixed worksheet count for every workbook; the practical number depends on available memory and system resources, along with the workbook’s content and complexity.
How to check a worksheet’s last row
To inspect the bottom of the worksheet, use the Name Box, the small box to the left of the formula bar that normally displays the active cell address. Click it, type A1048576, and press Enter. Excel selects the cell in column A at the worksheet’s final row. You can also use Ctrl+G on Windows to open Go To, enter A1048576, and select that location. On Mac, use Control+G or select Edit > Find > Go To, depending on the Excel version and menu layout.
That takes you to the grid’s last row; it does not tell you how many records your dataset actually contains. Ctrl+End on Windows moves to the worksheet’s last used cell as Excel currently recognizes it. On Mac, Command+End is commonly used, though laptop keyboards may require the Fn key. Formatting or previously entered and deleted content can make the reported used area extend farther than the visible data, so treat that shortcut as a navigation aid rather than a definitive record count.
For a simple list, inspect the column that should be populated for every record and locate its last nonblank value. Be careful with blank rows inside the list: they can make a quick jump to the next filled cell stop before the real end. If the data is an Excel table, its boundaries are usually easier to identify because the table has a distinct header and expands as contiguous records are added.
What happens when you reach the limit
When the last available row is occupied, Excel cannot add another worksheet row below it. If an operation would push cells beyond the grid—such as inserting a row where existing content would have to move down—Excel may stop the operation and display a message that it cannot shift nonblank cells off the worksheet. The exact message depends on the action and workbook state, but the underlying issue is the same: there is no row 1,048,577.
You can still edit or remove values in existing rows, and you can often make room by deleting records or moving some data elsewhere. But deleting only the visible contents may not always free space for an operation if formatting or other used cells remain at the bottom of the sheet. Before making structural changes, save a copy of the workbook and check whether any content, formulas, or formatting is present near the bottom.
A full sheet may also cause problems when importing or pasting a larger source. Data that exceeds the available worksheet rows cannot all be displayed in that sheet. Do not assume that a successful-looking import means every source record reached the grid; compare the source record count with the imported result, especially when the input is close to the limit.
Why a workbook may slow down before the limit
Excel’s maximum is a hard boundary, but it is not a performance target. A workbook can become slow with far fewer than a million records if it contains many formulas, conditional formatting rules, volatile calculations, complex lookups, or links to other workbooks. Large numbers of styles, shapes, or full-column calculations can add overhead too. The effect depends on the data, calculation workload, computer, and Excel edition.
For example, a plain list of several hundred thousand values may be easier to handle than a smaller sheet in which every row contains multiple formulas that recalculate whenever a cell changes. Formatting whole columns or applying elaborate conditional formatting across very large ranges can also make a file harder to manage. A workbook’s size on disk alone is not a reliable guide to how responsive it will feel.
When performance is poor, consider removing unnecessary formatting, limiting formulas to the rows that contain data, and avoiding repeated copies of large datasets. If calculations are not needed immediately, changing calculation settings can sometimes help during a specific task, but remember to restore the desired calculation mode afterward. These measures may improve a workbook; they do not raise the row limit.
What to do with more than 1,048,576 records
Choose a solution based on what you need to do with the records. If you only need to inspect or calculate selected parts of a larger source, importing and filtering data before loading it to a worksheet may be more efficient than trying to display everything at once.
- Use Power Query to filter or transform first. In Excel for Microsoft 365 on Windows, open Data > Get Data to connect to supported sources and use the Power Query Editor to shape the data. Load only the rows or columns needed for worksheet analysis, or use a connection or the Data Model where appropriate. The Data Model has different capacity constraints from a worksheet, but its practical capacity depends on memory and the model; it is not an unlimited store.
- Split the data across worksheets only when that suits the task. For example, separate records by year or region if users genuinely work with those groups independently. Document the split and keep column names and data types consistent. Splitting does not make combined analysis automatic, and it can complicate formulas, summaries, and updates.
- Use a database or another data platform for a large ongoing dataset. A database is better suited to storing and querying records beyond a worksheet’s grid. Excel can still be used to retrieve a filtered result or summary for reporting. Power BI may be appropriate for interactive analysis and reporting, depending on the data and organizational setup.
- Keep a complete source file and load a manageable extract. A CSV file is not restricted to Excel’s worksheet row count as a file format, but opening a very large CSV directly in Excel does not enlarge the grid. If the source has more records than the worksheet can hold, use an import workflow that selects or processes the needed data rather than relying on a worksheet to contain every row.
Before choosing, consider whether users need to edit individual records, run calculations, share reports, or preserve a complete historical archive. A workbook is convenient for analysis and smaller operational lists; a database or data platform is generally more suitable when the full dataset has outgrown the worksheet.
Excel desktop, web, and file-format differences
For current Excel, the standard worksheet limit is 1,048,576 rows. Excel for the web uses the same basic worksheet grid limit. The available experience can differ by platform and feature, but moving a large worksheet to the browser does not create additional rows.
File format is a more important distinction. The .xlsx format supports the modern worksheet size, while the older .xls format is associated with the 65,536-row limit. If Excel warns about compatibility when saving to an older format, review the warning rather than assuming the extra rows will be preserved. Keep a modern-format copy when you need to retain data that exceeds legacy limits.
Frequently Asked Questions
Does Excel have a million-row limit?
Not exactly. The maximum is 1,048,576 rows per worksheet, which is slightly more than one million. The limit applies separately to each worksheet.
How many rows can Excel hold with a header row?
If the header is in row 1, the sheet can hold up to 1,048,575 data rows beneath it, ending at row 1,048,576. Any additional header or notes placed on the sheet also occupy row positions.
Can I increase the maximum number of rows in Excel?
No. There is no setting that extends the worksheet grid beyond 1,048,576 rows. To work with more records, filter or transform the source, split it when appropriate, or use a database or data model for the larger dataset.
Does Excel for Mac have the same row limit?
Yes. Current Excel for Mac uses the same 1,048,576-row worksheet limit. Some navigation shortcuts and interface details differ from Windows, but the grid capacity does not.
Can a CSV file contain more rows than Excel?
Yes. CSV is a text format and does not impose Excel’s worksheet grid limit. However, opening that file directly in Excel cannot display more than the worksheet can hold. Use an import or data-processing workflow if you need to work with records beyond that limit.
How many rows did Excel 2003 support?
Excel 2003 and earlier supported 65,536 rows and 256 columns per worksheet. The modern worksheet limit was introduced with Excel 2007, so older .xls files need special care when they contain data created in a newer workbook.
Related
- Excel Not Summing Numbers? Causes and Fixes
- Excel Not Showing All Rows? Find and Restore Hidden Rows
- Excel Daylight Saving Time: How Dates and Hours Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Create an Outlook Distribution List From a CSVTo create an Outlook distribution list from a CSV, first import the CSV’s people as Outlook contacts, then…
- How to Delete a Page in a Word Resume TemplateTo delete a page from a Word resume template, select the page’s contents and remove them, then delete…
- How to Insert a Table of Contents in a Word DocumentTo insert a table of contents in Word, apply built-in heading styles to your section titles, click where…
- Wrap Text in Excel: Keep Long Cell Entries VisibleTo keep text wrapped in Excel, select the cell or range, then choose Home > Alignment > Wrap…
- Google Sheets IFS: Else Results, Syntax, and FixesGoogle Sheets’ IFS function has no separate else argument: if none of its conditions is true, it returns…
- Power Query Absolute Value: How to Use Number.AbsIn Power Query, use the M function Number.Abs to return a number’s absolute value: for example, Number.Abs(-25) returns…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.