Hi Narayan
I hadn't seen those links. I will give them a try. Thank you!
I think it might be a partial victory - all new workbooks/worksheets will have that default, but the settings of an existing workbook saved by someone else, when I open it, will probably take precedence.
King
Narayan
That is what I know how to do, but that solution requires I do it on every worksheet that I open (some of which I don't own, so I can't save changes in).
I want an excel default setting (perhaps like a template) that over-rides individual worksheet settings regarding display of...
I know how to turn off the display of zeros for individual worksheets. Can I make that the default setting for every worksheet I open - so that I don't have to repeat the process of turning off the display for every worksheet?
King