How do I set the Options to View Zero Values to be off always

Y

ydfoley

i always want the zero values to be set to where they never show. at present
i have to click this off every worksheet i have or start. is there anyway to
do this globally so that this is not an issue?
 
P

papou

Hello
You may consider creating an excel template (BOOK.XLT) with this option set
to off and then place the tempate into the excel startup folder.

HTH
Cordially
Pascal
 
Top