Profile photo for Ajay Anand

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;;@

View 5 other answers to this question
About · Careers · Privacy · Terms · Contact · Languages · Your Ad Choices · Press ·
© Quora, Inc. 2025