- Select the entire sheet or dataset and go to Data > Create a filter
- Click on the Filter icon at the top of any column, then click on Clear and select (Blanks).
- Now you can only see the empty rows. Click on the first empty row from the top, press and hold the Shift key and select the last empty row. Right click on any selected row and click Delete Rows.
- Finally, go back to the Data tab and click Turn off filter.
