delte multiple blank rows in excel

[Guest]

I have an address worksheet it has two columns. Name in column A and Adress
in column B
In the rows 1- 10,000 is the data , Some of the rows have no data ,
how can i delete all the blank rows without having to individually select
and delete each one .I have to have this done today and am totally loss on
how to do it . any help would be apreciated .
Is there a macro or something that can be used to delete all the blank rows?

Thanks
Steve

 

[Guest]

ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will do that for you..........

Vaya con Dios,
Chuck, CABGx3

 

[Jared Burlison]

No Steve, dont go to www.asap-utilities.com, it is untrusted site and
he/(who ever owns) might hack into your system.. you can if you want, but it
is untrusted!

 

[Guest]

This select withthe shift key or select while holding down the Control Key
works great BUT i have 10,ooo rows on this sheet and half of them have to be
removed

This is what i am trying to accomplish

 

[Guest]

holdng down the shift or the control key works great but i have 10.000 rows
in this sheet and need to delete about half of the to eliminate the spaces
and using the control or shift to select each row wil take forever

 

[Guest]

Steve,
Following steps are required
Apply Autofilter on the entire data including blank rows
Select a column in which a blank cell indicates a blank row.
Select the drop down for that column and select blank in it
Then delete all the rows.

 

[Guest]

Thanks ALok!! saved me hours !!!!

Steve,
Following steps are required
Apply Autofilter on the entire data including blank rows
Select a column in which a blank cell indicates a blank row.
Select the drop down for that column and select blank in it
Then delete all the rows.

 

[Gord Dibben]

Another method.

Select a column and F5>Special>Blanks>OK

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP