| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct and adding the total time in a column | Excel Discussion (Misc queries) | |||
| How to hide running total in successive cells in a column | Excel Worksheet Functions | |||
| Adding total dollars based on specific data from another column | Excel Discussion (Misc queries) | |||
| ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
| ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
Hybrid Mode
