How can I add additional rows beyond the 65,536 in excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with a list that contains greater than 65,536 rows. is there
any way I can add rows to a standard workbook?
 
Hi

Wait until the Release of the next version of Excel (currently known a
Excel 12). That will have 1048576 rows and 16384 columns. You will hav
all your problems resolved.


Best regards


Deepak Agarwa
 
Thanks, I appreciate it. when will that be released? what can i do in the
meantime?
 
Hi
One option is to spread your data over a number of sheets, and then use a
summary sheet at the end to do stuff like totals, averages, etc.
Remember, the 65,536 is a limit on each sheet, not the entire workbook.

HTH
Michael
 
Spread your data out over more than one worksheet?


Gord Dibben MS Excel MVP
 
It is intended to be released sometime in 2007.


Best regards


Deepak Agarwal
 
You must log in or register to reply here.

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

Can I increase row capacity beyond 65536 rows 2
What is the Excel 2007 rows limit for Excel 2003 macros? 0
I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS 3
saving files 1
Increase rows in worksheet beyond 65,536 row limit 2
Additional Rows and Columns in Excel 2007 1
How can I see more than 65,536 rows in Excel 2007? 2
Excel Row Limitation 6

Back
Top