Delete Blank Rows in Table Excel

1. Select the cells in one column from the top of your list to the bottom.
2. Make sure that all the blank cells in this selected range are the rows you want to delete.
3. Press the F5 key on your keyboard (or select Edit, Goto).
4. Click the Special button.
5. Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.
6. Now choose Edit, Delete, select the Entire Row option and click OK.