View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Can I suppress printing a line if a value = 0?

Apply Autofilter to that column and choose Custom | Not equal to | 0
(zero).

It will hide the rows that contain 0 in that column, and then you can
print out. Select All from the filter pull-down after printing.

Hope this helps.

Pete

On Jan 31, 11:57*am, Conroy wrote:
I am printing a chart of accounts but would like to suppress the lines for
which there a no values, so that the report won't have all these zero
balances showing