Question

In Excel 2019, the maximum number of rows in a worksheet is:

• A. 1,048,576
• B. 65,536
• C. 1,000,000
• D. 999999

Answer 1

Answer:

A. 1,048,576

• In Microsoft Excel 2019 (and all versions from 2007 onwards), the maximum number of rows in a single worksheet is 1,048,576.