See all How-To Articles

How to Highlight Blank Cells in Excel & Google Sheets

This tutorial demonstrates how to highlight blank cells in Excel and Google Sheets.

 

highlight blank cells initial data

 

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.

  1. First, select the entire data range. Then in the Ribbon, go to Home > Find & Select > Go To Special.

 

highlight blank cells 1

 

  1. In the Go To Special window, select Blanks, and press OK.

 

find blank cells 3

 

All empty cells are now selected.

 

highlight blank cells 2

 

  1. 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).

 

highlight blank cells 3

 

As a result, all empty cells in the range now have a blue background color.

 

highlight blank cells final data

 

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.