How to Delete Empty rows from Excel

1) If you want to remove only Empty cells just select all data click on F5 then Click on Special -> then select Blacks radio button and click Ok. It will select all Empty cell.

Then click CTRL+ '-' . It will ask to delete Cells up or only Cells or Only Cell rows.