Excel has a sheet setting that allows to stop zeroes from displaying in the whole sheet. There is a simple macro line of code that makes it easy to change.
Under File > Options > Advanced and scrolling down you can see the setting under Display options for this worksheet – see image below.
It takes a few clicks plus a long scroll to change the setting. It is a sheet-based option. Perfect for a macro solution.
A single line of macro code can make the change for you. I have set it up as a toggle macro, so running the macro switches between hiding and displaying zeroes.
The macro code is.
Sub Hide_Zeroes_Toggle()
ActiveWindow.DisplayZeros = Not ActiveWindow.DisplayZeros
End Sub