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."