How to Select Blank Cells

Please follow the steps below to select all the cells that are blank:

Step 1: Click anywhere in the worksheet;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Sort&Filter" and select "Go To Special" from the list;

Step 4: Check "Blanks" in the "Go To Special" window;

Step 4: Click "OK" at the bottom.

All blank cells are now in different color. Please check how to fill cells with a background color if necessary.

Leave a Reply