hiding rows containing zero values

[Bill Sullivan]

Is there a way that excel can completely hide rows where a
designated cell in that row contains a zero? I'm creating
a proposal form where the user selects the quantities of
certain items. I don't want the results to include all the
rows of items the user will not be including in the proposal.

Any ideas? Thanks.

 

[David McRitchie]

Hi Bill,
You can filter them out. Select the column, your can
select all columns if you like. Then Data, Filter, autofilter
click on the filter introduced at top of sheet, choose Custom
choose does not equal 0
To remove the filter: Data, Filter, click on Autofilter to turn it off.

A short introduction to filtering
Summarizing Data Examples (an Overview)
http://www.mvps.org/dmcritchie/excel/sumdata.htm

You will find a lot more on filters at Debra Dalgleish's site
http://www.contextures.com/tiptech.html