DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The number of rows in an Excel 2007 worksheet is:
|
|
65536
|
|
|
256
|
|
|
64536
|
|
|
1048576
|
Explanation:
Detailed explanation-1: -1, 048, 576 Is The Limit. Yes, Excel has maximum row limits! According to Microsoft Support (latest version): Excel’s maximum row limit is 1, 048, 576.
Detailed explanation-2: -Answer: Excel spreadsheets only hold 1, 048, 576 rows by 16, 384 columns. Anything more than that will not be loaded. If you run into this issue take the group you are working with and split it into 2 groups, and then try reporting on each group half separately.
There is 1 question to complete.