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 Visible Cells in Excel How to Select Non-adjacent cells in Excel? How to Deselect 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) Fill Down Blank Cells Until the Next Value in Excel (Formula, VBA, Power Query) How to Select Entire Column in Excel