/* BeejBløg */

Jan 10, 2012 - 1 minute read - Comments

Excel – Select (Delete) Blank Rows

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.