You could use an AutoFilter to hide the rows that are zero, then print
the sheet. There are instructions for AutoFilter in Excel's Help, and he

http://www.contextures.com/xlautofilter01.html

CCSWFL wrote:
Hi:

I create sets of financials for multiple entities in Excel based on a
standard template. Not all of the accounts are used in each entity. This
causes a line with a description and a zero to be returned. I need to find a
way to get rid of the lines with zero values and also, not leave a blank line
in its place. Is there a formula that can be used to do this?

Thanks!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html