Excel Max Row Count: How Many Rows Can a Sheet Hold?

How-to basics · Updated November 18, 2026

Microsoft Excel for Microsoft 365 supports a maximum of 1,048,576 rows per worksheet, numbered 1 through 1,048,576. That limit applies to the entire sheet, including headers and blank rows; with one header row, at most 1,048,575 rows remain for data.

The worksheet limit in context

Excel’s row maximum is part of a fixed worksheet grid: a modern worksheet has 1,048,576 rows and 16,384 columns. The final column is XFD. These limits apply to Excel for Microsoft 365 on Windows and are also used by current Excel versions on Mac and Excel for the web. A workbook can contain multiple worksheets, each with its own grid, but adding sheets does not enlarge any individual sheet.

The large row count can be surprising because a sheet may look nearly empty. Excel still defines the full grid even when most rows contain no values. The worksheet’s capacity is a structural limit, not a promise that every workbook can practically store or calculate that many populated records at once.

To check the bottom of a sheet, use the Name Box to the left of the formula bar: type A1048576 and press Enter. Excel selects the last row in column A. You can enter a different column letter if you want to inspect another column. This is more direct than scrolling through a million rows.

Does the header count as a row?

Yes. Excel counts every row position in the worksheet grid, whether it contains a heading, a record, a formula, or nothing at all. A table with one header row and 1,048,575 data records reaches the worksheet’s final row. If you use two rows for headings, notes, or other content above the records, the available space for records is reduced accordingly.

For example, if row 1 contains column names and records begin in row 2, the last possible record is in row 1,048,576. There is no additional row beneath it for a total, footnote, or newly appended record. Put totals above the data, calculate them elsewhere, or leave room by keeping the actual data range below the limit.

Formatting or formulas in otherwise empty rows do not create extra capacity. They can, however, make it harder to tell where the meaningful data ends or increase workbook size. A worksheet’s maximum remains fixed regardless of how many cells are currently populated.

How Excel’s row limit compares with older versions

The current grid limit dates to Excel 2007. Earlier versions, including Excel 2003, supported 65,536 rows and 256 columns per worksheet. This difference matters when opening legacy workbooks or saving a modern workbook in the older Excel 97–2003 format, which uses the .xls extension.

When a workbook is saved to a format with the older grid limits, data beyond the supported range cannot be represented on a single sheet in that format. Excel may warn about compatibility or require changes. Keep the workbook in a modern format such as .xlsx or .xlsm when you need the larger worksheet grid; the format choice does not remove the current worksheet maximum.

File extensions can be a clue, but they do not tell the whole story: a modern workbook may contain imported data, links, or features that affect compatibility in other ways. If a file must be shared with someone using an older Excel release, check the Compatibility Checker and confirm that the recipient can access the data they need.

What happens when data exceeds the maximum?

Excel cannot put a 1,048,577th worksheet row beneath row 1,048,576. If you try to add a row at the bottom of a full sheet, Excel cannot expand the grid further. Similarly, a paste or import that would extend past the final row cannot place all of its records into that worksheet. The result can be an incomplete transfer or a message that the operation cannot be completed, depending on the method used.

This is especially important when importing a CSV file. A CSV file is plain text and can contain more records than Excel can display in one worksheet. Opening a large CSV directly in Excel does not increase the grid: records beyond the worksheet capacity will not appear as extra rows in that sheet. Keep an untouched copy of the original file and verify the number of imported records before relying on a partial-looking result.

When data is split across sheets, remember that each sheet has its own limit. For instance, placing one million records on a first sheet and the remainder on a second can make the information fit across a workbook, but it also means analysis and maintenance may require combining the ranges or treating them as separate parts.

Rows, Excel Tables, and the Data Model

An Excel Table does not provide a way around the worksheet limit. A table is a structured range of cells on a worksheet, so its header and data rows must fit within that sheet’s available grid. Tables make data easier to filter, sort, format, and reference in formulas, but they do not create additional worksheet rows.

Power Query can help bring data into Excel and transform or combine sources. Depending on the load destination, a query can load results to a worksheet or to the workbook’s Data Model. A worksheet load is subject to the 1,048,576-row grid limit. The Data Model is a separate way to store and analyze tabular data, rather than a larger visible worksheet, and its practical capacity depends on available system resources and the data’s characteristics.

For analysis, loading a large source into the Data Model and using PivotTables may be more suitable than trying to display every record on a sheet. This approach does not mean the data has become unlimited: memory, file size, refresh time, and the design of the model still matter. Check the query’s row counts and refresh results so you know whether the full source was processed.

Maximum capacity versus practical capacity

A worksheet may technically have room for more rows than a particular computer can comfortably work with. A million rows of a few short text and numeric fields can behave very differently from a million rows containing long text, many formulas, conditional formatting rules, or complex styles. Workbook performance also depends on calculation settings, other open files, installed add-ins, and the computer’s available memory.

Some common signs that a workbook is becoming difficult to use include slow recalculation, long delays when filtering or sorting, a large file, and sluggish saving or opening. These symptoms do not necessarily mean the row limit has been reached. They can occur well before the final row, particularly when formulas refer to large ranges or many cells have been formatted unnecessarily.

  • Keep the source data in a simple, consistent layout, with one record per row and one field per column.
  • Remove genuinely unused rows, columns, and excess formatting when they have expanded the workbook’s used area.
  • Consider Power Query, the Data Model, a database, or a purpose-built data tool when analysis becomes slow or the dataset is larger than a worksheet can hold.
  • Save a backup before restructuring or splitting a large workbook, and check record counts after each transfer.

How to choose a practical way to handle large datasets

The right approach depends on whether you need to view every record, perform calculations, refresh data regularly, or simply preserve a source file. A worksheet is convenient for reviewing and editing a moderate-sized table. It may be a poor storage destination when a source contains more rows than the grid allows or when displaying every record is unnecessary for the analysis.

  • Use one worksheet when the complete dataset fits below the row limit and Excel remains responsive for the tasks you need.
  • Split the data across worksheets when separate sections are manageable and users can reliably identify and combine them. Document the split and avoid treating the sheets as unrelated datasets.
  • Use Power Query and the Data Model when you need to clean, combine, or summarize more data than you want to place directly on a worksheet. Confirm that refreshes include the expected records.
  • Use a database or another data platform when many users, frequent updates, or larger-scale querying are central requirements. Excel can still be used to inspect summaries or exported results.

Do not assume that breaking one file into several sheets automatically makes a reliable database. It can complicate sorting, deduplication, totals, and updates. If you split records, use a shared set of column names, preserve a unique identifier where possible, and validate the combined record count.

Frequently Asked Questions

What is the maximum number of rows in Excel 365?
Excel for Microsoft 365 supports 1,048,576 rows per worksheet. The row numbers run from 1 to 1,048,576, and the limit is per sheet rather than per workbook.

How many data rows can I have if I use a header?
With one header row, the maximum is 1,048,575 data rows on that worksheet. Each additional row used for headings or notes reduces the available data-row count by one.

Can Excel have more than 1 million rows?
A single worksheet cannot exceed 1,048,576 rows. A workbook can distribute information across multiple worksheets, or you can use the Data Model or an external data system, but these options do not extend the grid of an individual sheet.

Does a CSV file have Excel’s row limit?
No. CSV is a text format and can store more lines than an Excel worksheet can display. But opening an oversized CSV as a worksheet does not increase Excel’s row limit, so use a suitable import or data-analysis workflow and verify that all records were retained.

What is the maximum number of columns in Excel?
A modern Excel worksheet has 16,384 columns, ending at column XFD. The row and column limits together define the size of the worksheet grid.

How can I tell whether I have reached the last row?
Type A1048576 into the Name Box and press Enter to select the final row in column A. If your data already occupies that row, there is no further worksheet row available for another record.

Related

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.