Not Enough Rows in Excel

  • Thread starter Thread starter Joe_G
  • Start date Start date
J

Joe_G

I never thought I would run out of space in Excel however, lately I hav
been needing more rows than what excel will allow me. I have found tha
Excel allows for only 65,536 rows and no more.

I am wondering if anyone can tell me how to extend that. Are there an
programs that will increase the amount of rows allowed? I am thinking
would need around 150,000 rows.

Thank
 
You have, as I see it, three options:

Use QuatroPro (1 million rows)
Use additional sheets for your data
Use a database instead of Excel

There are NO workarounds to the 65536 row per sheet limit in Excel.

Good Luck!
 
Nope. If you are using it as data storage then you might want to consider
using Access to store the data, and you can then query the table with Excel
using Pivot tables or Query etc.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Hi Joe

Not much help at the moment, but when Excel 12 is eventually released, then
according to information released by Microsoft today,

"Specifically, the Excel 12 grid will be 1,048,576 rows by 16,384 columns.
That’s 1,500% more rows and 6,300% more columns than in Excel 2003,
and for those of you that are curious, columns now end at XFD instead of IV."

Regards

Roger Govier
 
Back
Top