Select all Blank Cells

Automate Excel

Select all Blank Cells

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

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.