Hiding rows based on a value
 

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.

Menu DataFilterAutofilter and select a value of 0.

--

HTH

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


"John" wrote in message
...
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.