The Maximum Number of Rows and Columns in Excel is …

Question

The maximum number of rows and columns in excel is …

1. 256 columns and 65356 rows
2. 256 columns and 65536 rows
3. 256 columns and 65635 rows
4. 265 columns and 65256 rows
5. 256 columns and 63536 rows

Answer

B. 256 columns and 65536 rows

Explanation

The answer choices for this question are a bit outdated since newer excel versions have many more columns and rows. However, if we talk about excel 1997-2003, then it indeed has 256 columns and 65536 rows per worksheet.

Excel 2007 onwards has 16,384 columns and 1,048,576 rows. To know the maximum number of rows and columns per excel version, here is a table that summarizes the information.

Excel Version	Number of Columns	Number of Rows
Excel 5	256	16,384
Excel 95	256	16,384
Excel 97	256	65,356
Excel 2000	256	65,356
Excel 2002/XP	256	65,356
Excel 2003	256	65,356
Excel 2007	16,384	1,048,576
Excel 2010	16,384	1,048,576
Excel 2013	16,384	1,048,576
Excel 2016	16,384	1,048,576
Excel 2019	16,384	1,048,576

Go back to the Compute Expert's excel quiz page