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.

--
Regards

Roger Govier


"Robert11" wrote in message
...
Hello:

I have a sheet with lots of blank rows.

Is there any way to compact things, and remove the blank rows all in
one shot ?

Thanks,
Bob