This post will guide you how to select blank cells or nonblank cells from a selected range in Excel. How do I select non-blank cells in a range of cells in Excel.
Select Blank Cells or non-blank Cells
Assuming that you have a list of data in range A1:D5, and you want to select all blank cells or non-blank cells in Excel. You can do the following steps:
#1 select the range of cells that you want to select the blank cells.
#2 go to HOME tab, click FIND & Select command under Editing group. And select Go To Special from the drop down menu list. And the Go To Special dialog box will open.
#3 select the Blanks option under Select section in the Go To Special dialog box. Click OK button.
Note: if you want to select all non-blank cells, you can select the Constants option in the Go To Special dialog box.
#4 you should notice that all blank cells are selected in the selected range.