Excel Row Limit: Max Rows & Columns Per Sheet (2026)
A single Excel worksheet holds 1,048,576 rows by 16,384 columns — roughly 17.2 billion cells. That last column is labeled XFD. Both numbers have been fixed since Excel 2007 and apply to every modern version, from Excel 2016 through Excel for Microsoft 365, per Microsoft’s Excel specifications and limits page.
The Limits at a Glance
Rows & columns
- Maximum rows per worksheet: 1,048,576 (Microsoft)
- Maximum columns per worksheet: 16,384, the last being column XFD (Microsoft)
- Total cells: about 17.2 billion (1,048,576 × 16,384)
Other worksheet limits
- Characters in a single cell: 32,767 (Microsoft)
- Maximum column width: 255 characters (Microsoft)
- Maximum row height: 409 points (Microsoft)
- Worksheets in a workbook: limited only by available memory (Microsoft)
Why It’s Exactly 1,048,576 (and Why .xls Stopped at 65,536)
These aren’t arbitrary round numbers — they’re powers of two. 1,048,576 is 2^20 and 16,384 is 2^14, which is how the file format addresses each row and column under the hood. The old binary .xls format (Excel 97–2003) used a narrower address space and capped out at 65,536 rows (2^16) by 256 columns. Excel 2007 introduced the .xlsx format and lifted both ceilings to today’s values.
That’s also why opening a modern workbook in an old .xls file, or saving down to it, can silently truncate anything past row 65,536 or column 256. If a file is full at exactly 65,536 rows, it’s almost always saved in the legacy format — switch to .xlsx.
How to Work With More Data Than Excel Allows
- Use Power Query to load and shape data without filling rows. Power Query can pull from files and databases, filter and transform millions of records, and load only the result you need into the grid — or skip the grid entirely and load straight to the Data Model.
- Build a Data Model with Power Pivot. The in-memory Data Model isn’t bound by the 1,048,576-row sheet limit, so you can analyze tens of millions of rows with PivotTables while the raw data stays out of the worksheet, as Microsoft describes in what to do when a data set is too large for the Excel grid.
- Move the raw data to a real database. For datasets that keep growing, Microsoft Access, SQL Server, or any SQL database stores the records and lets Excel connect to query a slice on demand.
- Split the file by time or category. If you must stay in worksheets, break the data into per-month or per-region files so no single sheet approaches the ceiling.
- Aggregate before you import. Summarizing at the source (daily totals instead of every transaction) often shrinks billions of rows down to thousands.
Troubleshooting
How many rows can Excel have?
A single worksheet holds up to 1,048,576 rows in the modern .xlsx format. A workbook can contain many worksheets, so total capacity across a file is limited mainly by your computer’s memory.
How many columns does Excel have?
16,384 columns, with the final one labeled XFD. Columns are lettered A–Z, then AA–ZZ, and so on up to XFD.
Why won’t Excel let me add more than 65,536 rows?
The file is almost certainly in the old .xls format, which caps at 65,536 rows. Save it as .xlsx (File > Save As, then choose Excel Workbook) to unlock the full 1,048,576-row limit.
Can Excel handle a million rows fast?
It can hold them, but formulas and PivotTables over the full grid get slow. For responsive analysis at that scale, load the data into the Power Pivot Data Model instead of the worksheet.
Quick Reference
| Limit | Value |
|---|---|
| Max rows (.xlsx) | 1,048,576 |
| Max columns | 16,384 (XFD) |
| Total cells | ~17.2 billion |
| Old .xls rows | 65,536 |
| Characters per cell | 32,767 |
| Max column width | 255 characters |
| Max row height | 409 points |
Hitting the row limit is a data problem, not a busywork problem — that’s where databases and Power Query earn their keep. Carly is an AI executive assistant that starts at $35/month and handles inbox and calendar work, not spreadsheets, though it does connect to Microsoft Excel when a workflow needs to read or write a sheet.
Related guides: The best AI agents for productivity
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."
