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.

Capture

Step 1

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

Capture




Step 2

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

Capture

Step 3

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

Capture

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.

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply