Select the range or entire worksheet
Press Ctrl+G or F5
Click Special
Select Blanks
Click OK
Right-click any selected blank cell
Choose Delete
Select Shift cells up or Entire row
Click OK
Use Filter to show blank rows
Select the visible blank rows
Right-click and choose Delete Row
Turn off the filter
Use Go To Special > Blanks and delete the rows if needed
Sort the data to move blank rows to the bottom
Delete the blank rows at the bottom
Use Power Query to remove blank rows from imported data
Use a formula or helper column to identify blank rows and delete them