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

You need to click on one(just once), and then hold shift and move the up or
down arrow until it highlights what ever you want, then you right click on
it and click delete.
"Steve Dont know how George" <Steve Dont know how
wrote in message
...
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

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



"Steve Dont know how George" wrote:

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

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!
"CLR" wrote in message
...
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



"Steve Dont know how George" wrote:

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

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

"Steve Dont know how George" wrote:

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

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


"Steve Dont know how George" wrote:

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

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.

"Steve Dont know how George" wrote:

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


"Steve Dont know how George" wrote:

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

Thanks ALok!! saved me hours !!!!

"Alok" wrote:

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.

"Steve Dont know how George" wrote:

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


"Steve Dont know how George" wrote:

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

Another method.

Select a column and F5SpecialBlanksOK

EditDeleteEntire Row.


Gord Dibben MS Excel MVP

On Fri, 6 Oct 2006 10:39:01 -0700, Steve Dont know how George
m wrote:

Thanks ALok!! saved me hours !!!!

"Alok" wrote:

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.

"Steve Dont know how George" wrote:

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


"Steve Dont know how George" wrote:

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