Excel - How can I keep accounts with 0 balances from printing on reports?

I am using an old copy of Quick Books Pro and am dumping into an Excell
spread sheet.  How do I not print old accounts with 0 balances? When I make
them inactive in Quick Books they still show up on all reports.  Thanks

Not really an Excel question unless you want to know how to delete the
rows with 0 balances. If you go to modify reports in QB select amount
and it should give you a choice of All, >, < , >=, <=.  Select > than 0.
This should limit all of the 0 balnces off your report.

gls858

You can do it with formatting   Format, Cells, Custom
Make the 3rd operand  empty
so if you   General     change it to    General;General;;

Also of interest   Tools, Options, View
[x] Zero Values     should be checked to show zero values
but you can  uncheck it and zero values will not show, but you
won't know if it is zero,  or empty, so it would be better to
do your exceptions with formatting.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

You can set up an autofilter to cover your Balance column, and then on
the pull-down for the filter select Custom | Does Not Equal | 0 (zero)
and then the rows which do contain 0 will be hidden.

Hope this helps.

Pete