Removing Blank Rows ?

[Robert11]

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

 

[Roger Govier]

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.

 

[Gord Dibben]

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

 

[Guest]

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