Row and Column Limits Explained

Excel holds 1,048,576 rows and 16,384 columns per sheet. Knowing the limits tells you when to stop.

Module 1 · Getting Started · Easy · 5 Minutes read

Where the Grid Ends

The last row is 1,048,576 and the last column is XFD. It sounds enormous, but a sheet slows down long before you reach either.

Rows — 1,048,576 of them
Columns — 16,384, ending at XFD
The real limit — Your computer's memory

How to do it

Ctrl + Down from an empty column ▸ row 1048576 Ctrl + Right ▸ column XFD

These limits apply to .xlsx. The old .xls format stopped at 65,536 rows and 256 columns.

Item	What it does
1,048,576	The last row number
16,384	The number of columns
XFD	The last column letter
65,536	The old .xls row limit

Format Limits Compared

Ctrl + Down ▸ 1048576 Ctrl + Right ▸ XFD

Format	Max rows	Max columns
.xlsx and .xlsm	1,048,576	16,384
.xls (old)	65,536	256
CSV	No limit in the file	Excel still caps it
Data Model	Hundreds of millions	Not applicable

Result: 1,048,576

Excel stops at a million rows. Power Pivot's Data Model goes far beyond it.

Do this

Know the limits before promising a client
Use the Data Model for very large data
Avoid .xls unless you must

Avoid

Assuming a CSV of two million rows will open
Saving big files as .xls and losing rows
Fighting Excel when a database is the right tool

📌 If your data is bigger than a few hundred thousand rows, Power Query and the Data Model handle it far better.

Practice

Press Ctrl + Down on an empty column.
Press Ctrl + Right to find column XFD.
Look up the old .xls limits.

Quick quiz: A colleague sends a CSV with 2 million rows and says Excel lost half of it. What happened?

The file was corrupt
Excel stopped at 1,048,576 rows because that is the sheet limit
The CSV format cannot hold that much

Show answer

Load it with Power Query into the Data Model instead of onto a sheet. — A worksheet caps at 1,048,576 rows. The Data Model does not.

🔒 Want the full interactive course? This is a free preview. The complete 39-module Excel Master Course — with hands-on lessons, quizzes and a certificate — is available inside the app.

Learn Excel the fun way
Bite-size interactive lessons, quizzes, streaks and a certificate.
Start free →