Question

How many rows are available in Excel 2007?

• A. 5663
• B. 65536
• C. 72257
• D. 4332

Hint:

For Excel 2007, the maximum number of rows is \( 65,536 \). If working with larger datasets, consider upgrading to newer Excel versions with expanded row limits.

Answer 1

The Correct Option is B

In Excel 2007, there are a total of \( 65,536 \) rows and \( 16,384 \) columns, extending from \( A1 \) to \( XFD65536 \). This row limit applies to older versions such as Excel 2003 as well. Later versions, starting from Excel 2010, expanded the row limit to \( 1,048,576 \).