delete blank cells in excel

by Ramya 2012-08-15 18:22:47

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.
507
like
0
dislike
0
mail
flag

You must LOGIN to add comments