My worksheet is several thousands of rows

  • Thread starter Thread starter vanilla bean
  • Start date Start date
V

vanilla bean

How can I get rid of all these extra rows - makes everything so slow and
awkward. How did it happen?
 
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.
 
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.

Edit>Delete>Entire 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

printing selection 2
Inserting Rows...but losing "FORMAT" 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
removing specific rows in a worksheet 8
Formula extends down to rows past data - very slow opening 4
Need to merge worksheets - Excel 2003 0
Getting rid of thousands of rows Excel 2002 3
Deleting unneeded rows and columns 1

Back
Top