Hide rows if cells = 0.00
 

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.

Hide rows if cells = 0.00
 

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" wrote:

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.

Hide rows if cells = 0.00
 

Thanks Bruce. That is what I was looking for.

"bpeltzer" wrote:

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" wrote:

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.