LIVE Course for free

Rated by 1 million+ students
Get app now
0 votes
in General by (54.0k points)
closed by
What is the maximum number of rows in a MS Excel 2010 worksheet? 
1. 16,384 
2. 1,048,500
3. 1,048,576
4. 16,000 

1 Answer

0 votes
by (30.0k points)
selected by
Best answer
Correct Answer - Option 3 : 1,048,576

The correct answer is 1,048,576.

  • Excel has a physical limit of about 1 million rows (1,048,576 rows). 
  • 1,048,576 is simply 2 to the 20th power, and thus this number is the largest that can be represented in twenty bits.
  • Old versions of Excel allowed 65536 rows (2 to the 16th power).
  • This was increased to 1048576 to address complaints that 65536 rows were too few.

Worksheet and workbook specifications and limits:

  • The total number of rows and columns on a worksheet - 1,048,576 rows by 16,384 columns.
  • Column width - 255 characters.
  • Page breaks - 1,026 horizontal and vertical.
  • Row height - 409 points.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.