In this article, I am going to show you two ways on how to find blank cells. Both techniques are quick and easy.
The first one allows you to find each blank one by one. The picture above shows you the first example, I want to find blanks in column D.
- Select the first value in the column you want to search.
- Press and hold CTRL key.
- Press down arrow key once.
This will move the selection right above the first blank cell in the same column, see picture below.
Press down arrow key twice still holding the CTRL key will move the selection to the next blank cell in your worksheet.
The second way lets you create a list of all blanks in your worksheet.
- Click on the first value in the column, then press CTRL + SHIFT + END keys to select all values including blanks in the column.
I have selected cell range D2:D355, see picture above.
Press CTRL + H to open the "Find and Replace" dialog box.
- Don't enter anything, simply click on the "Find All" button.
The dialog box now shows all blank cells with their location, see picture below.
Click on a row in the dialog box to instantly move to and select that blank cell.
Tip! Use the "Find and Replace" dialog box to fill blank cells with a value. The example below replaces all blank cells with S.
Read the following post on how to fill blank cells with a formula:
The following post shows how to quickly select all blank cells in a cell range:
How to quickly select blank cells