How can we select all blank cells in Excel?

by

If you wish to select all the blank cells in Excel, then you can use the Go To Special Dialog Box in Excel. Below are the steps that you can follow to select all the blank cells in Excel.

  • First, select the entire dataset and press F5. This will open a Go To Dialog Box.
  • Click the ‘Special‘ button which will open a Go To special Dialog box.
  • After that, select the Blanks and click on OK.
    The final step will select all the blank cells in your dataset.