how do I get rid of extra rows

G

Guest

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??
 
D

David McRitchie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I cannot delete the extra rows or columns in Excel 2007 2
Deleting extra rows in Excel 07 2
How do I get rid of duplicate rows? 5
CANNOT DELETE AUTOPHAPES ARROWS FROM WORKSHEET 3
In Excel, how do I get blank rows and columns to print? 6
How do I get rid of a blank row at bottom of Excel spreadsheet? 1
How can i get rid of two red lines on my spreadsheet? 2
How do I get rid of unused rows at the bottom of the book? 1

Top