MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Delete rows with zero in a certain column

Posted by sjt on July 31, 2001 2:06 PM

I need a quick and painless way to delete the entire row if there is a zero in Column E. Any help?

Posted by Mark w. on July 31, 2001 2:08 PM

Apply an AutoFilter for rows with 0 in column E,
and then delete all visible data rows.