How to quickly delete blank rows in Microsoft Excel 2007

In Microsoft Excel 2007, go to the Home Tab > in the Editing Group select Find and Select.  Choose Go To Special… > select Blanks and then ok.  Then in the Cells Group > use the down arrow on the Delete command and chose Delete Cells, then Shift cells up.  That will do it.