There are many reasons you may want to select all blank cells in a range or worksheet, here’s how.

On the main menu bar

1. Click Edit

2. Click Go To…

3. Click the Special… button

4. Select Blanks and hit OK