Hide A row based on a value in that row?

  • Thread starter Thread starter Rusty Shackelford
  • Start date Start date
R

Rusty Shackelford

I would like to hide Rows that are not going to be needed. These rows are
going to have a #DIV/0! in a cell. Is it possible to hide rows that contain
these cell values?
 
How about applying Data|filter|Autofilter to your range (or column???).

then you could use a custom filter to show the values that don't equal #Div/0!
 
SWEET THANKS!
Dave Peterson said:
How about applying Data|filter|Autofilter to your range (or column???).

then you could use a custom filter to show the values that don't equal #Div/0!
Click to expand...
 
Back
Top