I have a Excel Doc that has bout 4,000 rows...don't know how that happened.
Tried to delete by clicking Select All/ Delete but that doesn't seem to work..

Any ideas on How to delete that many rows???

Thanks..

Hi Roberto,

Visit Debra Dalgleish's site and see her note on resetting the Used Range:

http://www.contextures.com/xlfaqApp.html#Unused


---
Regards,
Norman



"Roberto" wrote in message
...
I have a Excel Doc that has bout 4,000 rows...don't know how that happened.
Tried to delete by clicking Select All/ Delete but that doesn't seem to
work..

Any ideas on How to delete that many rows???

Thanks..

Roberto

All Excel worksheets have 65,536 rows and 256 columns.

You cannot delete these. You can hide them if they bother you.

Select those you don't want to see and FormatRowHide.

Gord Dibben Excel MVP


On Wed, 8 Dec 2004 15:35:03 -0800, "Roberto"
wrote:

I have a Excel Doc that has bout 4,000 rows...don't know how that happened.
Tried to delete by clicking Select All/ Delete but that doesn't seem to work..

Any ideas on How to delete that many rows???

Thanks..

Thank you!

"Norman Jones" wrote:

Hi Roberto,

Visit Debra Dalgleish's site and see her note on resetting the Used Range:

http://www.contextures.com/xlfaqApp.html#Unused


---
Regards,
Norman



"Roberto" wrote in message
...
I have a Excel Doc that has bout 4,000 rows...don't know how that happened.
Tried to delete by clicking Select All/ Delete but that doesn't seem to
work..

Any ideas on How to delete that many rows???

Thanks..