how to filter an excel sheet in which we want to avoid a particular row where a particular row contains zero?

Answer 1

1. highlight the column in question by clicking on letter at top
2. go to Data --> Filter --> Autofilter
3. click the down arrow in row 1
4. select "custom"
5. in the "show rows where" field, select "does not equal"
6. in the value field, type "0"
7. hit OK

Answer 2

delete the row