I have a large spreadsheet, and for some reason on one page, there are some
5000 extra rows at the bottom. There's nothing in them - I've selected them
all, cleared the contents, and asked Excel to delete them, but they won't go
away. They're making the spreadsheet even larger, and the page navigation
that much more difficult. Why won't they go away??

Hi Sarah,
One thing that you have to do to finalize things is to save the file.
I find that trying to do everything without using a macro usually misses.
Suggest you try the macro on Debra Dalgleish's site to fix all of the
worksheets in the workbook.. You cleared the cells you have to actually
delete the rows and save.
Why do my scrollbars go to row 500 -- my data ends in cell E50?, contextures.com,
http://www.contextures.com/xlfaqApp.html#Unused
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"sarahtar" wrote in message ...
I have a large spreadsheet, and for some reason on one page, there are some
5000 extra rows at the bottom. There's nothing in them - I've selected them
all, cleared the contents, and asked Excel to delete them, but they won't go
away. They're making the spreadsheet even larger, and the page navigation
that much more difficult. Why won't they go away??