Highlight Blank Cells In Excel

Let’s see how to highlight all the cells in a sheet in excel that contains blank.

We are often come across a situation where we have to make the entries in the blank cell, and among the other cells with values it becomes quite a challenging task to see for blanks to fill them with the values or “NA” or 0.

We will see an easy example as to how to highlight the cells with blank in excel.

Below is the sample data in which we want to highlight the cells with blank.


Step 1

Select the data part in the table and press keyboard shortcut Ctrl+G to open the Go to option in excel.


Step 2

Click on “Special” option at the bottom left corner and select the blank, press OK.


Step 3

It will show you all the cells in your selection with blank.


Step 4

Now format them as you wish, you could color them with some different color to distinguish them from rest of the cells.

I have made them grey.


Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply