Not Enough Rows in Excel

[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

 

[swatsp0p]

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!

 

[Ian]

The only workaround is to continue onto another sheet.

 

[Ken Wright]

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
------------------------------­------------------------------­----------------

 

[Timothy L]

Start another Worksheet.

Insert a new worksheet
http://office.microsoft.com/en-us/assistance/HP052008891033.aspx

These instructions in the link above are for Microsoft Excel 2003, but should work in other versions of
Microsoft Excel.

 

[Joe_G]

Thanks for the advice. I will look into some alternative programs.

 

[Roger Govier]

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