We've been asked how to remove blank rows in Excel an absurd amount of times, so we decided to post it as it truly is a FAQ.
While there are a few ways, here is a super simple one that anyone should be able to follow.
Press the F5 Key to cause the "Go To Special" dialog box to pop up.
This will highlight all blanks in the sheet. From here, simply delete the rows that are selected.