View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
User
 
Posts: n/a
Default How to remove a lot of rows? Please help

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