get rid of extra rows

[Guest]

I have this nice spreadsheet, but somehow additional rows were created at the
bottom, and I can't get rid of them by "deleting", backspace, editing and
deleting the formatting in those rows. Suggestions?

 

[JE McGimpsey]

You can't change the number of rows in an XL sheet (65536 pre-XL07, over
a million in XL07). You could hide them instead (Format/Row/Hide).

 

[David McRitchie]

See if this helps -- use the macro.
# Why do my scrollbars go to row 500 -- my data ends in cell E50?, contextures.com, Debra Dalgleish.
Use the macro solution. The basis of deletions is all columns without content, and all rows without content.
http://www.contextures.com/xlfaqApp.html#Unused

If that doesn't work, because you do actually have spaces in cells, see
Making the activecell the LastCell (#MakeLastCell)
http://www.mvps.org/dmcritchie/excel/lastcell.htm#MakeLastCell