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?

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

In article ,
kendallzemp wrote:

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?

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...m#MakeLastCell
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"JE McGimpsey" wrote in message ...
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).

In article ,
kendallzemp wrote:

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?