Excel – Select (Delete) Blank Rows

From here: http://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.