Get Mystery Box with random crypto!

If you need to hide zeros in a certain range of cells, then it | Excel Today


If you need to hide zeros in a certain range of cells, then it is not necessary to resort to conditional formatting. You can use the number format. It is enough to specify how to display positive numbers, how to display negative numbers, and not to specify anything for zero values. For example, like this:

The main; -The main;

The last semicolon opens the format block of zero values. If you do not specify anything after them, the zeros will not be displayed, although they will remain in the cells.
For more details on ranges, read the article.