How to remove empty rows in Excel?

To remove empty rows in Excel:

1. Simply highlight and select all rows
2. Press Ctrl + G, then click Special button
3. Click Blanks radio button, Click Ok
4. Go to Edit --> Delete or right click and delete