Excel maximum Row number

X

xiaoniao

Why excel worksheet limit the row number to maximum 65536 only ? From my
calculation report, I really need to run the calculation to more than 65536
row, otherwise, I have to separate into two calculation with all the
worksheet function. This is really tidious for me to sort out all the result.
Is there any other way to extend the maximum row tange ?
 
S

Stefi

Use Excel 2007, it has one million rows.
Regards,
Stefi


„xiaoniao†ezt írta:
 
R

ryguy7272

If you can work exclusively in a Pivot Table you won't be subjected to that
65,535-row-limit-issue.

Regards,
Ryan--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Challenging Excel Problem 0
Exceed Row Limit 4
Max function for row with named cells 3
Function in Excel to count and list number of entries of text valuesin a row. 2
Display row of the maximum in a list 2
Formulas within list fail to update after sorting/filtering 0
Maximum value within a time range 7

Top