get rid of extra rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kendallzemp - 13 Sep 2007 15:30 GMT

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?

Reply to this Message

JE McGimpsey - 13 Sep 2007 15:42 GMT

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

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

Reply to this Message

David McRitchie - 14 Sep 2007 05:55 GMT

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

Signature

HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

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

Reply to this Message

Rate this thread: