What is the maximum number of rows in a modern Microsoft Excel worksheet?

A. 1,048,576

B. 65,536

C. 16,384

D. 1,000,000

Explanation

A modern Excel worksheet contains 1,048,576 rows. The smaller 65,536-row limit belongs to the older Excel 97–2003 worksheet format.

Source

Microsoft Support — Excel specifications and limits

Answer verified on 2026-09-21

Found an error? Read our corrections policy and submit a sourced correction below. You can also share a useful explanation in your own words.

Discuss the answer or suggest a sourced correction
Thank you for contributing.
Your comment was submitted and will appear after editorial review.

Your email is used only for moderation and is never displayed. Spam, copied material and fabricated endorsements are rejected.