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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - adding function- can you hide the 0.00 in the total column (https://www.excelbanter.com/excel-worksheet-functions/173469-adding-function-can-you-hide-0-00-total-column.html)

Lynn

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

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

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

Tools Options Zero Values

Regards,
Ryan--

--
RyGuy

"Lynn" wrote:

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?

Pete_UK

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

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

On Jan 17, 4:20*pm, Lynn wrote:
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?

All times are GMT +1. The time now is 12:18 PM.