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

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

Robert

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

F5SpecialBlanksOK

EditDeleteEntire Rows.


Gord Dibben MS Excel MVP

On Sun, 12 Nov 2006 16:15:40 -0500, "Robert11" wrote:

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

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



"Robert11" wrote:

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