Delete/Remove Blank Rows In Excel

Ever inherited a monster of a spreadsheet?- silly questions we all have!, and more often than not one of the little issues with it is..those blasted blank cells.. that interrupt any data analysis we...