An easy way of hiding rows is to set up Autofilters - then you can
choose a criteria for which to hide the rows (e.g. select Custom from
the pull-down, then Does Not Equal and 0 (zero) to display only the
non-zero rows).

Hope this helps.

Pete