How to remove a lot of rows? Please help

[User]

Hi,

I have an Excel sheet with some columns and lots of rows.
In one of the columns a lot of cells are equal 0 (zero as a number,
not as a result of any fomula).
I need a simple method of removing all rows if there is 0 in the column.

I'll be very grateful for your help.

Regards,
User

[Ron de Bruin]

Hi User

You can use AutoFilter for 0 and then delete the visible rows
After you filter do this

1) Be sure that the active cell is in the filter range
2) Press Ctrl * to select all data or use F5>Special>Current region>OK
3) Press Alt ; to select all visible data or use F5>Special>Visible cells only>OK
4) Ctrl - to delete the rows

Or use code to do it
http://www.rondebruin.nl/delete.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"User" <[email protected]> wrote in message news:[email protected]...
> Hi,
>
> I have an Excel sheet with some columns and lots of rows.
> In one of the columns a lot of cells are equal 0 (zero as a number,
> not as a result of any fomula).
> I need a simple method of removing all rows if there is 0 in the column.
>
> I'll be very grateful for your help.
>
> Regards,
> User
>

[User]

Hi Ron

Thank you very, very much. That's what I needed.
I've visited your site and found lots of interesting things.
Thanks again.

Best regards
User


Użytkownik "Ron de Bruin" <[email protected]> napisał w wiadomości news:[email protected]...
> Hi User
>
> You can use AutoFilter for 0 and then delete the visible rows
> After you filter do this
>
> 1) Be sure that the active cell is in the filter range
> 2) Press Ctrl * to select all data or use F5>Special>Current region>OK
> 3) Press Alt ; to select all visible data or use F5>Special>Visible cells only>OK
> 4) Ctrl - to delete the rows
>
> Or use code to do it
> http://www.rondebruin.nl/delete.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "User" <[email protected]> wrote in message news:[email protected]...
>> Hi,
>>
>> I have an Excel sheet with some columns and lots of rows.
>> In one of the columns a lot of cells are equal 0 (zero as a number,
>> not as a result of any fomula).
>> I need a simple method of removing all rows if there is 0 in the column.
>>
>> I'll be very grateful for your help.
>>
>> Regards,
>> User
>>
>
>