On the Home tab, click the Find & Select button, then choose Go To Special (keyboard shortcut: F5, Alt + S) Select the Blanks radio button on the Go To Special window.
Select cells from D2 to D6 and use Ctrl + F.Enter 1 and click Find All.Select all the values and click Close. The column must ONLY contain blank cells where the entire row is blank. Let’s say, that you want to keep only the rows with blanks. It checks whether the value of a cell is blank. The better way here is to use the COUNTBLANK(value) formula.