Excel Row Count Limit: Maximum Rows and What It Means

In current versions of Microsoft Excel, a worksheet can contain up to 1,048,576 rows. That is the limit for one sheet, not the whole workbook: a workbook can have multiple worksheets, but no individual sheet can extend beyond row 1,048,576.

The exact row limit in modern Excel

The maximum applies to Excel for Microsoft 365 on Windows and to current Excel versions on Mac and the web. It also applies whether the worksheet is mostly empty or filled with data. The grid always has the same row capacity; using fewer rows does not increase the number of columns available, or vice versa.

Excel worksheets also have a limit of 16,384 columns, ending at column XFD. Taken together, those limits describe the maximum grid size of one worksheet. They do not mean that a typical workbook can practically fill every cell: the amount of data, formulas, formatting, and available computer memory can make a workbook slow or too large to work with well long before the grid is full.

The row limit includes every row position, not just rows containing data. A table header, title, notes, and blank rows all occupy positions in the grid. For example, if a dataset has one header row and 1,048,575 data rows, it fits exactly. A header plus 1,048,576 data rows would need 1,048,577 worksheet rows and therefore would not fit on one sheet.

Why Excel has a row limit

A worksheet is a fixed grid with defined dimensions. Excel uses row and column addresses to identify cells, such as A1 or XFD1048576. The maximum row number is part of the worksheet specification, rather than a setting that users can increase by changing an option or buying a larger computer.

The current grid dimensions arrived with Excel 2007, when Microsoft expanded the worksheet from the much smaller grid used by earlier releases. The modern limit gives each sheet over a million rows, enough for many lists, exports, and analyses. It remains finite because worksheet features are designed around a bounded grid, and because a very large grid can require substantial processing and memory.

More worksheet rows do not automatically make Excel a database. A spreadsheet is convenient for arranging, calculating, and examining data, but a huge, detailed dataset may be better stored in a database or processed with data tools that are designed for larger tables.

How to check the last row and count data

The row headers along the left edge show the worksheet’s numbering. To jump to the bottom, use the Name Box to the left of the formula bar: enter A1048576 and press Enter. You can also press Ctrl+Down from a cell in a column to move through a contiguous block of data, though that shortcut finds the edge of a data region, not the worksheet’s absolute limit.

If you want a formula to report how many rows a range contains, put the formula in an available cell. With the worksheet’s entire column A as the range, =ROWS(A:A) returns 1,048,576. This counts the grid positions in column A, including blank cells; it does not count records.

For a record count, choose a column that should be filled on every record. With record identifiers in A2:A1001 and a header in A1, =COUNTA(A2:A1001) returns 1,000 when all 1,000 identifier cells contain values. COUNTA counts cells that are not empty, including cells containing formulas that display an empty string, so it may not match the number of visibly populated records if the column has formulas or gaps.

Excel’s bottom status bar can also show a count after you select cells, depending on the selection and status-bar settings. That count is a convenience, not a measure of the worksheet’s capacity. It may count selected nonempty cells rather than all rows in the sheet.

Older Excel versions and file formats

Excel 97–2003 worksheets have a smaller maximum of 65,536 rows and 256 columns. That older format is commonly associated with the .xls file extension. Modern .xlsx and .xlsb workbooks use the larger worksheet grid, subject to Excel’s other workbook and system limits.

When a current workbook is saved in the older .xls format, Excel may enter Compatibility Mode and warn that some features or data are incompatible. The older row limit matters if the workbook must be opened or saved in that format: data beyond the supported range cannot be represented as ordinary worksheet rows in an .xls file. Keep a modern-format copy if you need to retain the full dataset, and check compatibility warnings before saving over an original.

If a file from another program appears to stop at row 65,536, the cause may be the file format or the application that created it, rather than the current Excel worksheet limit. Check the file extension and whether Excel reports Compatibility Mode before assuming the data was intentionally limited.

What happens when a dataset exceeds the limit

Excel cannot add worksheet row 1,048,577. Pasting or loading more records than fit on the sheet may leave some records out, produce an error, or require you to choose another destination, depending on how the data is brought into Excel. Opening a large CSV directly is especially worth treating carefully: a CSV file can contain more lines than Excel can display as worksheet rows, but the worksheet grid cannot show them all.

For an import that is too large for a sheet, use Power Query or another data tool to connect to and transform the source, then choose an appropriate destination. In Excel for Microsoft 365 on Windows, the Get Data options are available on the Data tab. Power Query can load results to a worksheet, where the worksheet row limit still applies, or to the workbook’s Data Model, which is not displayed as a regular grid. The Data Model’s practical capacity depends on factors such as memory, data shape, and the computer and workbook environment; it is not a way to create extra visible worksheet rows.

Excel for Mac and Excel for the web have the same modern worksheet row limit, although available import, data-model, and Power Query features can differ by platform and version. If a particular command or destination is missing, check the capabilities of that Excel edition rather than assuming its worksheet has a different row capacity.

Choosing a practical option for large data

The best response to a large dataset depends on whether you need to store every record, inspect a subset, or calculate summaries. Consider these options:

Filter or summarize the source. If you only need totals by month, region, or product, aggregate the data before loading it to a sheet. This can reduce the worksheet output while preserving the information relevant to the question.
Use Power Query and the Data Model. This is useful when you need to import, clean, combine, or analyze more records than fit on one worksheet. It avoids placing every row in the visible grid, though computer resources still matter.
Split the output across sheets or files. This can work for simple, separate batches that people need to inspect. Keep a clear key and consistent column headings so the pieces can be identified and recombined safely.
Use a database or data-processing tool. For recurring analysis, many users, or datasets that keep growing, a system built for larger structured data may be more reliable than a workbook full of split lists.

Splitting a dataset across sheets is not always the easiest answer. Formulas, pivots, and checks may have to account for every sheet, and users can accidentally omit a section. If the records form one logical table, storing them in a suitable data source and bringing only the needed summary into Excel is often simpler.

Common misconceptions and problems

Adding worksheets does not raise the per-sheet limit. A workbook may hold data on several sheets, but each sheet still stops at row 1,048,576. Moving some records to a second sheet increases the total stored across the workbook, not the size of either sheet.

Formatting a blank row does not create more capacity. Formatting, filters, tables, and frozen panes do not change the final row number. They can affect file size or performance, but the grid remains fixed.

A row count is not the same as a record count. The worksheet has 1,048,576 row positions whether it contains one record or none. A count of nonblank cells in one column is only a useful record count when that column is reliably populated once per record.

Workbook slowness can arrive before the limit. Formulas that calculate across large ranges, volatile functions, extensive conditional formatting, and repeated copies of data can all add work. If Excel slows down, reducing unnecessary calculations or formatting may help, but it will not increase the maximum row number.

Frequently Asked Questions

Can I increase the Excel row limit?
No. There is no worksheet setting that raises the fixed maximum of 1,048,576 rows in modern Excel. To work with more records, use multiple sheets or, more often for a single large dataset, Power Query, the Data Model, a database, or another suitable tool.

Does Excel have 1,048,576 rows per workbook?
No. The limit is per worksheet. A workbook can contain multiple worksheets, each with its own grid, but the practical total is affected by memory, file size, and performance.

How many rows can an Excel table have?
An Excel table is located on a worksheet, so it cannot extend beyond the worksheet’s final row. Its header and any totals row also occupy worksheet rows; leave space for those when planning a table close to the grid limit.

Can Excel open a CSV with more than 1,048,576 lines?
A CSV can contain more lines than a worksheet can display. Opening it as a sheet cannot make the worksheet larger, so some rows may not be available in the grid. Use an import or data-processing workflow that can handle the source and load an appropriate subset, summary, or model instead.

Is the row limit different in Excel for Mac or Excel for the web?
Current versions have the same worksheet limit of 1,048,576 rows. Some data-import and analysis features vary by platform or edition, but that does not change the worksheet’s maximum row number.

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.