As PCMag's resident data journalist, I practically live in Microsoft Excel. I've learned that it's capable of far more than I ...

Go to File > Options > Advanced and scroll all the way down to Display options for this worksheet. Uncheck the box next to Show a zero in cells that have zero value, and they'll appear as a blank.