How to Turn Zero to Blank in Cells that Have Zero Value

The Excel will show zero by default, but if you want to hide them and turn zero into the blank cells in a worksheet, please see the steps below for details:

Step 1: Click the "File" Tab from the ribbon;

Step 2: Click "Options" from the left navigation menu;

Step 3: Click "Advanced" from the left navigation menu;

Step 4: Uncheck the box of "Show a zero in cells that have zero value" under the section "Display options for this worksheet";

Step 5: Click "OK" at the bottom.

Leave a Reply