delete blank cells in excel

delete blank cells in excel

* Select the entire column for which you want to delete the blank cells.
* Press F5
* Select "Special" button
* From the options, choose "Blanks" and Hit "Ok"
* Now the blank cells are selected.
* Right and delete the entire row.
* All blank cells will get deleted.