You may want to look at Data|filter|autofilter

Then you can show rows that are not equal to 0.

Likepike wrote:

if a1=0 then hide row

--

Dave Peterson