Excel Row Limit: How Many Rows Can a Worksheet Hold?

In Microsoft Excel for Microsoft 365, a worksheet can hold a maximum of 1,048,576 rows. That is the number of rows in one sheet, not necessarily the amount of data Excel can work with through other tools; the worksheet grid itself cannot be extended beyond that boundary.

The exact Excel row and column limits

The final row in a current Excel worksheet is numbered 1,048,576. A worksheet also has 16,384 columns, ending at column XFD. These are fixed grid dimensions in modern Excel, including Microsoft 365 for Windows; having a more powerful computer does not add rows or columns to a sheet.

The limit counts every row, whether it is blank or contains data. If row 1 contains column headings, there are at most 1,048,575 remaining rows for records on that sheet. For example, a list with one header row and 1,048,575 data records fits exactly. A further record will not fit as another worksheet row.

The limit applies to each worksheet, rather than to a workbook as a whole. A workbook can contain multiple sheets, each with its own grid, although the practical amount of data a workbook can manage depends on available memory and the work being performed. Adding sheets does not create one continuous grid: formulas and analysis across sheets require deliberate references or a suitable data tool.

Why Excel has this limit

Excel’s grid is a defined worksheet structure, not an infinitely growing table. The current dimensions were introduced with Excel 2007 and have remained the worksheet limits in later desktop versions, including Microsoft 365. They are large enough for many ordinary lists, reports, and departmental datasets, but can be restrictive for detailed transaction histories or machine-generated records.

Older Excel workbooks use a smaller grid. The Excel 97–2003 format, commonly saved as an XLS file, is limited to 65,536 rows and 256 columns, with the last column labeled IV. When an older workbook is opened or saved in a newer Excel version, its file format matters: saving in the older format can make data beyond the old limit unavailable in that file. Excel may show compatibility warnings when a workbook contains features or data that the older format cannot preserve.

For new work, XLSX is the usual workbook format, while XLSB is another modern Excel workbook format. Neither changes the worksheet’s maximum row number. Choosing a different modern workbook format can affect file size or performance, but it does not make a sheet taller.

How to check the last row in your worksheet

You can jump directly to the bottom row without scrolling through the sheet. In Excel for Windows, click the Name Box to the left of the formula bar, type A1048576, and press Enter. Excel selects cell A1048576. You can use another column letter if you want to inspect a different column in the final row.

Another option is to press Ctrl+Down from a selected cell. This moves to the edge of the current block of data or to the bottom of the worksheet, depending on what is in the cells below. It is useful for navigating a populated column, but it is not a reliable way to count records: blank cells can break up a data block, and cells far below the visible portion may still contain content.

To find the last row that contains anything, press Ctrl+End on Windows. Excel moves to what it considers the last used cell, which may be farther down or to the right than the visible data if formatting or past edits extended the used range. That result is not necessarily the last meaningful record. Check the relevant column or use filters and data-cleaning steps when an accurate record count matters.

What happens when you reach row 1,048,576?

Excel cannot insert a new worksheet row below row 1,048,576. If you try to add rows when the sheet is already full, Excel will prevent the operation or report that it cannot shift cells off the worksheet. The same boundary affects operations that need to expand a range, such as pasting additional records at the bottom.

There is no setting to raise the row limit, and changing zoom, splitting panes, hiding rows, or converting a range to a table does not create extra worksheet space. A table is still located on the worksheet grid, so it cannot extend past the last row. Likewise, moving data to another sheet gives it another grid, not additional rows in the original sheet.

Be careful when importing or pasting a dataset that exceeds the available space. The source file may contain more records than the worksheet can display. Do not assume that seeing a successful import of the first part means the entire source is now present. Compare the source record count with the number loaded, and choose a method that retains all records if the total exceeds the sheet limit.

Worksheet rows versus records and table rows

A worksheet row is a position in Excel’s grid; a record is a logical item in your dataset. Usually one record occupies one row, but the two are not always equal. A title, a notes section, blank separator rows, or multiple header rows all use grid positions without being data records. Conversely, one record might be spread across several rows in a poorly structured layout.

For a simple list with one heading row, the maximum theoretical record count is 1,048,575. If the sheet uses three rows for headings and explanatory notes, the maximum space left for records is 1,048,573, assuming no other rows are reserved. These are mathematical capacity figures, not a recommendation to fill every cell.

Excel tables make lists easier to filter, sort, and reference, but they do not bypass the worksheet ceiling. A table with a header uses a worksheet row for that header, and its data rows must still occupy the sheet. A table also cannot include more rows than the worksheet can hold. If the list is approaching the maximum, plan a different storage or analysis approach before it becomes difficult to update.

Working with data larger than one sheet

Excel can help analyze data that is too large to load into a worksheet grid, but the method matters. Power Query can connect to and transform data from supported sources. Its output can be loaded to a worksheet, where the worksheet limit still applies, or loaded as a connection and, where appropriate, into the Excel Data Model instead of being placed in the grid.

The Data Model is designed for analytical relationships and measures across tables, and it can handle data volumes beyond a single sheet’s row count. It does not have a simple universal row allowance that applies to every computer and workbook: practical capacity depends on memory, data types, compression, model design, and whether Excel is 32-bit or 64-bit. A model with repeated text values and a compact structure may use resources differently from one with many unique values and complex calculations.

For a large dataset, consider these options:

Use Power Query and the Data Model when you need to clean, combine, relate, or summarize data without putting every record on a sheet.
Use a database or data platform when the source is routinely larger than a spreadsheet, needs multiple users, or requires dependable storage and querying at scale.
Split data into separate sheets or workbooks only when the data is naturally divided and cross-partition analysis remains manageable. This is a workaround, not an increase to the per-sheet limit.
Summarize before loading when the task needs totals by date, product, or category rather than every underlying transaction in the worksheet.

For Power Query in Microsoft 365 on Windows, the Data tab includes Get Data options for connecting to sources. Loading a query to a worksheet is different from loading it as a connection or into the Data Model; choose the destination intentionally. If all rows must remain available for analysis, confirm that the query and model contain the full source rather than relying on a worksheet preview or partial grid output.

Performance and practical capacity

Excel’s maximum row count is not a promise that every workbook with more than a million populated rows will run smoothly. A workbook can become slow well before reaching the grid limit, especially if it has complex formulas, volatile calculations, extensive conditional formatting, many pivot tables, links to other files, or large numbers of distinct text values.

Memory also matters. The 64-bit edition of Excel can use more memory than the 32-bit edition, subject to the computer’s resources and other limits, which can help with larger workbooks and Data Models. It still cannot add rows to a worksheet. For performance, use only the necessary columns, avoid formatting entire columns without a reason, remove obsolete rows and columns, and summarize or filter data before analysis when that preserves the required detail.

File size alone does not reveal whether a workbook will perform well. Two files with the same number of records can behave differently because of formulas, formatting, data types, workbook structure, and calculation settings. If routine work regularly approaches the worksheet ceiling, the more durable fix is usually to change how the data is stored or queried, rather than to keep dividing a single list by hand.

Frequently Asked Questions

Does Excel 365 have more rows than older Excel versions?
Microsoft 365 uses the modern worksheet limit of 1,048,576 rows and 16,384 columns. Excel 2007 and later use the same grid dimensions. The older Excel 97–2003 XLS format is limited to 65,536 rows and 256 columns.

Can I increase the number of rows in an Excel worksheet?
No. The worksheet dimensions are fixed. You can use another sheet or a tool such as Power Query and the Data Model to work with more data, but no setting or worksheet feature increases the maximum row number.

How many data rows can I have if my first row is a header?
With one header row, you can have up to 1,048,575 data rows on that sheet. Every additional row used for titles, notes, or extra headings reduces the space available for records.

Can an Excel table contain more than 1,048,576 rows?
No. Tables occupy worksheet cells and cannot extend beyond the worksheet’s last row. A table header also takes up a row within the grid.

Does a CSV file have Excel’s row limit?
A CSV file is a text format, not an Excel worksheet, so the worksheet limit does not define how many lines the file itself can contain. Excel can display only up to its worksheet capacity when loading data into a sheet. Keep the original file intact and use a suitable data connection or database workflow if it contains more records than the grid can hold.

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.