adding function- can you hide the 0.00 in the total column

[Lynn]

I have a worksheet that have colums of added numbers. In the total column is
there a way to not see the 0.00 in the unused total column when I print out
the page?

 

[ryguy7272]

Tools > Options > Zero Values


Regards,
Ryan--

 

[Pete_UK]

Apply a filter to the totals column, and select Custom | Not Equal To
| 0 (zero) then click OK - this will hide the rows where the total is
zero.

Hope this helps.

Pete