An Excel worksheet holds 1,048,576 rows by 16,384 columns. That ceiling is per sheet, and the number of sheets in a workbook is limited only by available memory.
If your data has stopped at a suspiciously round-looking row, you've probably met the ceiling. Here are the numbers Microsoft lists on its Excel specifications and limits page, as of Nov 2026, followed by how to tell if you've hit one and what to do about it.
Excel's worksheet limits at a glance
| What | Limit |
|---|---|
| Rows per worksheet | 1,048,576 |
| Columns per worksheet | 16,384 |
| Characters in one cell | 32,767 |
| Line feeds per cell | 253 |
| Column width | 255 characters |
| Row height | 409 points |
| Header or footer | 255 characters |
| Page breaks | 1,026 horizontal and vertical |
| Sheets in a workbook | Limited by available memory (default is 1 sheet) |
| Open workbooks | Limited by available memory and system resources |
Two of those rows matter far more than the rest. The row ceiling is fixed. The sheet count isn't: Microsoft says it's limited by available memory. That difference is the whole key to working around the limit, and we'll come back to it.
Diagnosis: have you hit row 1,048,576?
The row ceiling is a hard edge of the grid. Every worksheet stops at row 1,048,576, so there's no next row for extra data to land in. If your source data is bigger than that, the extra rows can't live on that one sheet.
Here's how to check. Jump to the last row of your data and read the row number. If it sits right at 1,048,576, treat that as a red flag rather than a coincidence. Then compare it with the row count you expected from the system that exported the file. If the export said more, part of your data isn't on the sheet.
Be careful with what you assume next. Microsoft's limits page lists the ceiling, but it doesn't describe how Excel behaves when you open a CSV that's longer than the grid, or how Power Query and the Data Model handle large row counts. So don't trust a total, an average or a lookup on a sheet that stops at the ceiling until you've confirmed nothing got left behind.
The same logic applies to wide files. If your data has more fields than 16,384 columns, it won't fit across one sheet either. That's rarer, but survey exports and some ad platform reports can get very wide.
Signs you're close to the other caps
- Text cut off in a cell: one cell holds up to 32,767 characters in total.
- A long note with many line breaks that won't take any more: the maximum is 253 line feeds per cell.
- A print layout that won't accept more breaks: page breaks are capped at 1,026 horizontal and vertical.
- A row you can't make any taller: row height tops out at 409 points.
- A header that won't take more text: headers and footers hold 255 characters.
Most people never get near these. If you do, it's usually a sign the sheet is doing a job a database or a separate document would do better.
Workarounds when your data is too big
Start with the fact Microsoft gives you: sheets in a workbook are limited by available memory. So the simplest route is to split the data across several sheets, each under the row ceiling. Split on something meaningful, such as one sheet per year, region or product line, so each sheet makes sense on its own.
Second, ask whether you need every row in Excel at all. Often you need a summary, not the raw log. Aggregate the data before it reaches the spreadsheet, then bring in the totals. Fewer rows, faster workbook, fewer surprises.
Want AI doing the heavy lifting in your marketing?
I build the systems that handle the boring 80 percent, so you get your week back. Done properly, with the human kept in.
Third, split the source file before you open it, so each part fits on one sheet with room to spare. Microsoft's page doesn't cover how to cut a large CSV into parts, so use whatever export or filter options your source system offers to pull the data in chunks.
Once your data is spread across sheets, you'll need lookups that pull from the right place. If you're still on VLOOKUP, this walkthrough of INDEX and MATCH is worth ten minutes, because it copes better with data that moves around. And if you'd like help writing the formulas, there's a round-up of the AI tools that work inside spreadsheets.
Memory, not rows, is often the real wall
Here's the catch most people miss. Microsoft says open workbooks are limited by available memory and system resources, and so is the number of sheets. So even if you split a huge dataset neatly across sheets, your computer can still run out of room before Excel's own limits kick in. If a big workbook crawls or crashes, the problem may be your machine, not the row count.
That's why I'd treat the row ceiling as a warning light. If you're anywhere near it, Excel is probably the wrong home for the raw data, even if it's the right place for the report you build from it.
Not covered by Microsoft's limits page
- How to cut a very large CSV into Excel-sized parts.
- Exactly how Excel handles a CSV import with more rows than the grid.
- Row handling in Power Query and the Data Model.
Quick answers
How many rows can Excel handle?
One worksheet holds 1,048,576 rows by 16,384 columns. The number of sheets in a workbook is limited by available memory.
Can I increase the Excel row limit?
No, the row ceiling per worksheet is fixed. You can split data across several sheets, since sheets are limited only by available memory.
How many characters fit in one Excel cell?
A cell can contain a total of 32,767 characters, with a maximum of 253 line feeds.
Why does my Excel file stop at row 1,048,576?
That's the last row on any worksheet. If your source data was longer, the extra rows aren't on that sheet, so check the original row count.
