My worksheet is several thousands of rows
 

How can I get rid of all these extra rows - makes everything so slow and
awkward. How did it happen?

My worksheet is several thousands of rows
 

typically, some data got put in there and only cells were deleted. Highlight
your blank rows and delete them, then go back to the top and save. This
should get rid of yoru blanks.

"vanilla bean" wrote:

How can I get rid of all these extra rows - makes everything so slow and
awkward. How did it happen?

My worksheet is several thousands of rows
 

You cannot get rid of extra rows and columns but you may have a distorted
used range.

When you hit CTRL + End where does Excel take you?

If below and right of your actual data range you must reset the used range.

Select row below data and SHIFT + End +Downarrow.

EditDeleteEntire Rows.

Do not just "Clear Contents"...............you must use "delete".

Do same for columns to the right of data.

SHIFT + End + Rightarrow.

Now IMPORTANT..........save the workbook.

Some earlier versions of Excel will require a save then close and reopen to
see the new used range.


Gord Dibben MS Excel MVP

On Tue, 8 Sep 2009 13:05:01 -0700, vanilla bean <vanilla
wrote:

How can I get rid of all these extra rows - makes everything so slow and
awkward. How did it happen?