Quickly Remove Blank Row in Excel

Here's a handy way to help you to remove any blank row in a long list.

1. Remove any blank column manually.
2. Select the 1st blank cell in the 1st column.
3. Hit F5 (Edit, Goto).
4. Click Special.
5. Select the Blank option and click OK. This will select all the blank row for you.
6. Now, choose Edit, Delete, select the Entire Row option and click OK.