In this guide, you’ll learn how to stop Excel from calculating blank cells as zeros by creating efficient, reusable solutions that differentiate between actual zeros and blank cells.

1. How to highlight blank cells in Excel Blank cells are easy to miss if you’re working with a lot of data, so you might want to highlight them. The best way to do so is with a conditional format.