How to remove empty rows in excel

1. In an empty column alongside your table, insert this formula:
=COUNTBLANK(A5:G5)

where A5 = starting column of your table
and G5 = ending column of your table

2. Select the rectangular area containing all filled cells, then
HOME > SORT & FILTER > FILTER

This will create several dropdown buttons for each column header

3. Now click on the dropdown for your COUNTBLANK column. Select only the option which reflects empty rows (e.g. "7")


4. Now you can easily highlight all the empty rows, then rightclick and select "Delete rows"

5. Finally, let the COUNTBLANK dropdown show the other filled rows. Then delete the COUNTBLANK column.

Fin.