Click the home tab in the menu bar.
Click "Find & Select."
Select "Go To Special."
Select "Blanks."
Then hit "OK."
Then find the delete icon on the top of the screen.
Access the drop-down menu
by clicking the downward arrow on the right.
Click "Delete Sheet Rows."