How to Quickly Select Blank Cells in Excel

A lot of times I work with data that has blank cells in it. If not handled, this could create havoc when these blank cells are referenced in formulas. I usually fill these blank cells with 0 or NA (Not Available).

In huge data sets, it is practically impossible (or highly inefficient) to do this manually. Thankfully, there is a way to select blank cells in Excel in one go.

Select Blank Cells in Excel

Here is how you can Select blank cells in Excel:

1. Select the entire data set (including blank cells)
2. Press F5 (this opens the Go To dialogue box)
3. Click the Special.. button (this opens the Go To special dialogue box)

4. Select Blanks and click Ok (this selects all the blank cells in your dataset)

5. Type 0 or NA (or whatever you want to type in all the blank cell)
6. Press Control + Enter (keep the Control key pressed and then hit Enter)
7. Pat your back. It’s done 🙂

You May Also Like the Following Excel Tutorials:

• 3 Quick Ways to Select Visible Cells in Excel.
• How to Move Rows and Columns in Excel.
• How to Select Every Third Row in Excel (or select every Nth Row).
• How to Select 500 cells/rows in Excel (with a single click).