Excel 2007 : Delete blank rows where data entire cell contents are blank

One way is to add an extra column containing sequential numbers 1,2, etc which you can get by typing in the first few, selecting all of them and dragging down with the fill handle.

Then sort the sheet by one of the other columns so that the blanks rows go to the bottom.

Then delete the sequential numbers for the blank rows.

Finally sort by the sequential number column to get back to the original sequence.

An alternative is to use autofilters and select the blanks. Then right click and delete the selected rows.