I like to use this:

Select column C
Data|Filter|autofilter
Filter to show the 0's
delete the visible rows
data|filter|autofilter to remove that filter.

MCSHMCH wrote:

I mean column C. I want to delete all rows with a value of 0 in column C.
thanks!

"MCSHMCH" wrote:

Is it possible to delete rows automatically with specific criteria? Say I
want to automatically delete all rows that have a value of 0 in row c. Thanks!

--

Dave Peterson