Hide rows if cells = 0.00

D

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.
 
B

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
 
D

dford

Thanks Bruce. That is what I was looking for.

bpeltzer said:
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
Click to expand...
 
Top