You could do it with EditFind.

Select the column and EditFind

What: 0

Find All

Now in the "Found" dialog box hold SHIFT key and scroll to bottom and select
last "found" cell.

EditDeleteEntire Row.


Gord Dibben MS Excel MVP

On Tue, 12 Aug 2008 03:58:01 -0700, TheLearner
wrote:

Hello Everyone,

I have a file that has 4 columns, one of which stores a number value.

When this column has a value of 0 I want to remove the entire row.

Can I do this with Find/Replace or how would I do this?

Regards,