Need help deleting Rows

Roberto · Dec 8, 2004

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

Norman Jones · Dec 8, 2004

Hi Roberto,

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

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

Gord Dibben · Dec 9, 2004

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 Format>Row>Hide.

Gord Dibben Excel MVP

Roberto · Dec 9, 2004

Thank you!

Norman Jones said:
Hi Roberto,

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

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