get rid of extra rows
 

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?

get rid of extra rows
 

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?

get rid of extra rows
 

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?