Display only nonzero items in a table???

[Lovebaby]

If I have a table with 5 columns and I want to only display rows with
nonzero entries of one of the columns...

What is the best way to do this?

I want to be able to integrate this into a macro, also.

Thanks

 

[Dave Peterson]

I'd select the range (include one row of headers) and use
data|filter|autofilter

Then filter to show the not equal to 0 cells/rows.

You could record a macro if you want the code.

 

[Ben Woerdeman]

Tools>options>view>
disable zero values and the zero will not schown anymore

 

[Dave Peterson]

That'll make the cells with 0's look blank, but it won't hide the rows.