Hiding rows based on a value

J

John

I am looking for a way to hide a row based on the value in a cell.

EG: a price list which hides rows where the quantity column is '0' so that
when you print it / view it on screen you only see relevant rows.

Thanks.
 
B

Bob Phillips

Menu Data>Filter>Autofilter and select a value of 0.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top