Zero Lines in Spreadsheets (removing)
 

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!

Zero Lines in Spreadsheets (removing)
 

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