Need help deleting Rows
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.. |
All times are GMT +1. The time now is 02:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com