Zero Lines in Spreadsheets (removing)

[Guest]

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]

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 here:

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