delte multiple blank rows in excel

  • Thread starter Steve Dont know how George
  • Start date
S

Steve Dont know how George

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
 
S

Steve Dont know how George

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
 
S

Steve Dont know how George

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
 
A

Alok

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.
 
S

Steve Dont know how George

Thanks ALok!! saved me hours !!!!

Alok said:
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.
Click to expand...
 
G

Gord Dibben

Another method.

Select a column and F5>Special>Blanks>OK

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP
 
Top