How to Highlight Blank Cells in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on November 29, 2022

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 highlights 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, go to the Home tab, click on the arrow next to the Fill Color icon, and 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” feature. You’d have to identify blank cells one by one, select them, and then format them.

  1. Identify the first blank cell, and then, holding down the CTRL key, click on other blank cells.


highlight blank gs select


  1. In the Toolbar, select the Fill color drop down and then select your color.


highlight blank gs highlight


See also

AI Formula Generator

Try for Free

See all How-To Articles