Delete rows or columns with zero values

How to delete rows that contain zero values?

Sometimes you may be having a list of names and corresponding values. Certain names may contain zero values and to delete those names one by one, would rather turn out be a nightmare task. To do this within a few clicks, just follow the steps:

• Goto DATA->FILTER and select AUTOFILTER
• You would see a arrow mark in all the columns. This is the FILTER button
  
• Now go the column that contains zero values and click the FILTER button.
• The FILTER button would display the list of all values in the column in a drop-down box. Now select 0 from the drop-down box.
• The FILTER button would turn into BLUE color and would display all the zero values. Now RIGHT CLICK and select DELETE ROW.
• Click the FILTER button again and select ALL to display the values again.