Hide rows if cells = 0.00

[dford]

I am trying to hide rows if any cell in a columm = 0.00. Example: If any cell
in column D = 0.00 than hide the row containing that cell.

 

[bpeltzer]

Highlight your data, then from the menu bar select Data > Filter >
Autofilter. Select the drop-down in column D and choose Custom. Use the
drop-downs to set your selection to read 'does not equal' '0.00', then click
OK. Those rows with 0.00 in column D should now be filtered out (they're
still in your data, just not visible).
--Bruce

 

[dford]

Thanks Bruce. That is what I was looking for.

Highlight your data, then from the menu bar select Data > Filter >
Autofilter. Select the drop-down in column D and choose Custom. Use the
drop-downs to set your selection to read 'does not equal' '0.00', then click
OK. Those rows with 0.00 in column D should now be filtered out (they're
still in your data, just not visible).
--Bruce