Remove all the blank cells and rows with Go To Special command in Microsoft Excel

1. Select the range containing blank rows you want to remove.
2. Click Home > Find & Select > Go To Special.

3. In the Go To Special dialog box, check the Blanks option.

4. And then click OK, all of the entire blank rows are highlighted. Then click Home > Delete > Delete Cells,then select shift cells up then  the blank cells have been deleted from the selected range.
 
To delete rows, repeat  steps 1 to 3 then, all of the entire blank rows are highlighted. Then click Home > Delete > Delete Sheet Rows, the blank rows have been deleted from the selected range.

See screenshots:

Referred from :here