Let’s see how to check blank cell in excel.
ISBLANK () formula in excel is used to check blank cell in excel and return true or false depending whether the cell is blank or not respectively.
ISBLANK (value) takes reference to a cell and returns true/false.
We are interested to check what are the blanks cell in the below given column.
Enter the ISBLANK(reference) formula as shown below.
As shown below, the TRUE value indicates the blank cells.
Hope this helped.