Suppress zero showing in cells that have zero value

[dahowarduk]

This can be achieved via file ~ options ~ advanced options ~ (then after much scrolling down) ~ untick show a zero in cells that have zero value.
Is it possible to set this zero suppress as a default option, whenever I open a new spreadsheet?
Alternatively is it possible to add a' special 'tab' to the toolbar which can be clicked on, to then suppress zeros?
Thanks

 

[p45cal]

I did this and put the icon/button in the Quick Access Toolbar (QAT):



It's a one line macro which I put (recorded, initially) in the Personal workbook so that it's always available in any workbook:



then edited the macro to:

Sub ToggleZeros()
ActiveWindow.DisplayZeros = Not ActiveWindow.DisplayZeros
End Sub

Then added it to the QAT:

How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar - Excel Campus

You can quickly and easily add buttons to the Excel ribbon or Quick Access tolbar to run customized macros and make your job simpler.

www.excelcampus.com

 

[dahowarduk]

Thanks. I'll give it a try.

 

[dahowarduk]

I got as far as "edit the macro to...", when I got a message "can't edit macro in hidden worksheet', but it wasn't hidden!

Help please

 

[p45cal]

Excel Personal Macro Workbook: how to create, use and share

See how to create and use the Personal Macro Workbook (Personal.xlsb file) in Excel to make macros available in all workbooks.

www.ablebits.com

edit: updated, first link not v good.