Why do hidden zeros in worksheets re-appear?

[Pete Mccann]

I prefer that zero values in worksheets are hidden so the non-zero values are clearer on the screen. I normally do this by "File/Options/Advanced/Display/Options for this worksheet" and uncheck the box that has "Show a zero ...". This works fine until I open up a new window "View/New Window" and put this second window onto a second monitor so both sheets are visible side by side. The zeros then re-appear. Does anyone know why this happens? Also, is there a way to hide the zeros in the whole workbook (rather than hiding each sheet separately). I have tried to "select all sheets" and then to do the "File/Options/Advanced/Display/Options for this worksheet" command and it seems to work ....until I create a new Window.....then the zeros come back.

 

[Hui]

Set your own template for new workbooks
Setup a file with the properties and Number formats you want

Please read:
https://support.office.com/en-us/ar...d-sheets-8f3c2396-3883-4e3e-a668-8254aeff6a0f
Goto the section "Use a custom template for all new workbooks"

 

[Pete Mccann]

Many thanks for the quick reply Hui. The link you provided is great (and I will use that going forward). Is there anyway to apply this "custom template" to an existing file?