Rows of what? Data or just blank rows?

An Excel worksheet has 65536 rows and 256 columns(2007 version has over one
million rows and 16,384 columns)

None of these can be deleted.

Data can be deleted or cleared but the rows and columns remain the same number.


Gord Dibben MS Excel MVP

On Tue, 26 Feb 2008 12:55:05 -0800, JoAnn
wrote:

Anyone have any idea why I wouldn't be able to delete rows in a worksheet?
It doesn't seem to be protected for row deletion.

I am selecting the whole row (from the left side of the sheet) & then going
to the end of the sheet to grab the bottom.

I have over 6,000 rows in this one sheet! No idea how it happened or how I
can get rid of them (other than copy/paste what I want to save into a new
worksheet).

Thanks!
JoAnn