USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How many rows are there in an Exel 2007 document
|
|
65536
|
|
|
256
|
|
|
1048576
|
|
|
16384
|
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.
Detailed explanation-3: -Number of Rows per Worksheet: 1, 048, 576.
There is 1 question to complete.