arrow
arrow
arrow
The maximum number of Rows in a MS-Excel worksheet are :
Question

The maximum number of Rows in a MS-Excel worksheet are :

A.

65,534

B.

1,048,576

C.

10,68,576

D.

Unlimited

Correct option is B

In MS Excel (starting from Excel 2007 onwards), the maximum number of rows available in a single worksheet is 1,048,576. Earlier versions of Excel (such as Excel 2003) had a maximum of 65,536 rows, but the limit was increased significantly in later versions to support larger data sets.
Important Key Points:
1. Excel Row Limit - 1,048,576 rows and 16,384 columns are the maximum in Excel versions 2007 and onwards.
2. Sheet Specifications - These increased limits make Excel more powerful for data analysis, allowing users to store and analyze significantly larger datasets.
Knowledge Booster:
• 65,534: This number is incorrect. In Excel 2003, the limit was 65,536 rows, not 65,534.
• 10,68,576: This number is not a valid specification for Excel; the actual number of rows is 1,048,576.
• Unlimited: The number of rows is not unlimited. It is fixed at 1,048,576 in Excel 2007 and newer versions.

Free Tests

Free
Must Attempt

National Weekly Current Affairs Jan 2025 Practice Set 01

languageIcon English
  • pdpQsnIcon25 Questions
  • pdpsheetsIcon25 Marks
  • timerIcon15 Mins
languageIcon English
Free
Must Attempt

Bihar Police SI 2025 Mock : 01

languageIcon English
  • pdpQsnIcon100 Questions
  • pdpsheetsIcon200 Marks
  • timerIcon120 Mins
languageIcon English
Free
Must Attempt

BSSC CGL General Science Section Test 01

languageIcon English
  • pdpQsnIcon25 Questions
  • pdpsheetsIcon100 Marks
  • timerIcon20 Mins
languageIcon English
test-prime-package

Access ‘Bihar Civil Court’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
259k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow