Hi Robert

One way
Sort the sheet, and all the blank rows will "fall" to the bottom.
If the existing order is important to you, use a spare column, insert 1
in the first cell, 2 in the second cell, then mark both cells and double
click on the fill handle (small black cross when you hover over bottom
right of marked cells) and it will fill in a series of numbers.
Delete all rows below your true data, then sort on the new numbered
column to get rows back to original order.

Robert

Maybe this will work for you on a column with the blank rows.

F5>Special>Blanks>OK

Edit>Delete>Entire Rows.

Gord Dibben  MS Excel MVP

ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will do this for you nicely...........

hth
Vaya con Dios,
Chuck, CABGx3