DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
65, 535
|
|
|
65, 536
|
|
|
65, 636
|
|
|
66, 535
|
Detailed explanation-1: -Excel 2003 supports a maximum of 65, 536 rows per worksheet.
Detailed explanation-2: -Yes, Excel has maximum row limits! According to Microsoft Support (latest version): Excel’s maximum row limit is 1, 048, 576. Columns are limited to 16, 384.
Detailed explanation-3: -65, 536 rows. 256 columns. 255 worksheets in a workbook.
Detailed explanation-4: -xlsx or . xlsm) has a maximum of about 1 million (exactly 1048576) rows per worksheet. If the data source contains more than 65536 rows (and fewer than 1 million rows) and you are using ExcelWriter version 7.0 or higher, you can use ExcelTemplate with an OOXML template so that all data fit into a single worksheet.
Detailed explanation-5: -MS Excel versions up to and including 2003 enable the application to store only 65536 rows. In MS Excel 2007 or higher, the application can store 1, 048, 576 rows. There is no way to force Excel to retrieve more data than the maximum number of rows in a single transaction.