Hiding rows based on a value

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top