Excel doesn't have that ability.

Maybe you could use data|Filter|autofilter and hide the rows that are zero?

Briant wrote:

In Lotus, I used to place double pipes "||" within a print range and this
would keep rows that had a zero value from printing. Thius was very useful
when prining long invoices. It keeps rows that have a zero value from
prinnting, thus only printing the rows that have a total in them. Does
anyone know how to do this in Excel?

--

Dave Peterson