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:
- Select the entire data set (including blank cells)
- Press F5 (this opens the Go To dialogue box)
- Click the Special.. button (this opens the Go To special dialogue box)
- Select Blanks and click Ok (this selects all the blank cells in your dataset)
- Type 0 or NA (or whatever you want to type in all the blank cell)
- Press Control + Enter (keep the Control key pressed and then hit Enter)
- 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).