From here: https://www.theexceladdict.com/_t/t031008.htm Reflecting Microsoft’s current button naming in Excel 2010…
- Select a column possessing representative blanks, from top to bottom.
- F5.
- “Special…” button – here’s where the magic happens…
- “Blanks” radio button.
- “Delete” ribbon button/menu (under Home tab) – “delete sheet rows” menu item.