This tutorial demonstrates how to highlight blank cells in Excel and Google Sheets.
Highlight Blank Cells
There is an easy way to highlight all the blank cells in any selected range in Excel. Although this method won’t show you the number of blank cells, it will highlight all of them so you can easily locate them in a spreadsheet.
- First, select the entire data range. Then in the Ribbon, go to Home > Find & Select > Go To Special.
- In the Go To Special window, select Blanks, and press OK.
All empty cells are now selected.
- In the Ribbon, (1) go to the Home tab, (2) click on the arrow next to the Fill Color icon, and (3) choose a color (blue).
As a result, all empty cells in the range now have a blue background color.
Note: With this method, you won’t find pseudo-blank cells (cells with formulas that return blanks and cells containing only spaces).
For an alternate method, see Highlight Blank Cells – Conditional Formatting.
Highlight Blank Cells in Google Sheets
Unlike Excel, Google Sheets doesn’t have a Go To Special feature. You’d have to identify blank cells and highlight them one-by-one.