Microsoft Excel MVP · Author has 938 answers and 4.5M answer views · 4y ·
To hide every zero value in an entire worksheet,
Go to File Tab > Options > Advanced > Unmark the checkbox against the label Show zero in cells that have zero value
After that, even if the cells have zero value, the cells won’t display it.
If you want to hide zero values in selected cells use the following Custom Format
0;-0;;@
4.6K views ·
View upvotes
· View 1 share
· 1 of 6 answers