Imagine having an excel file with 50.000 filled cells with many empty cells between them and you want to remove them. It is very simple:
Edit –> Go To
Click on Special and choose blanks.
Then just right click in one empty cell from the selection and choose delete row.
It is that simple 😀