Hiding rows
 

Is there any way to hide a single row based on a value in the row? Or in a
value in another row?

Hiding rows
 

Manually / Automatically?

One way would be to use a helper column and then have an IF statement or
perhaps a VLOOKUP, that returned a value such as "Show" or "Hide" based on
whatever criteria you want to set. You can then just use Data / Filter /
Autofilter to show just the "Show"s

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"bobb" wrote:

Is there any way to hide a single row based on a value in the row? Or in a
value in another row?