never show zeros.


R

RolfeH

how do I globally turn off "zeros". I can go to "Excel Options, Advanced,
show a zero in cell that have zero value" and "uncheck it" but, I have to do
it on every file I open. Can I have it ALWAYS turned off??
thanks,
RolfeH
 
Ad

Advertisements

G

Gord Dibben

This is a worksheet setting only, not a workbook or global setting.

For all new workbooks and worksheets you could create new default book and
sheet templates.

For existing books............run a macro to set on all sheets.


Gord Dibben MS Excel MVP
 
Ad

Advertisements

K

Khoshravan

Select all sheets in a workbook go to options and do as you mentioned. Save
the workbook as template. Next time open the template. The changes you made
are there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top