Select the data range or the entire worksheet
Press Ctrl+G, then click Special
Select Blanks and click OK
Right-click any selected blank cell
Click Delete
Choose Entire row
Click OK
Alternatively, apply a filter to the data
Filter for blanks in a key column
Select the filtered blank rows
Right-click and choose Delete Row
Clear the filter
Alternatively, sort the data so blank rows move together
Select the blank rows
Delete the selected rows
Alternatively, use Go To Special to find blanks in a specific column
Delete the corresponding rows
Save the workbook