HowTo: Excel – Delete all blank rows.
After selecting the data range, continue as follows:
1. Press [F5].
2. In the resulting Go To dialog box, click Special.
3. Click the Blanks option and click Ok. Doing so selects the blank cells (what you might think of as rows) in the selected range.
4. Now you’re ready to delete the selected cells.