How to remove empty cells only in excel

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 😀