Removing Blank Rows ?

  • Thread starter Thread starter Robert11
  • Start date Start date
R

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
 
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
 
Back
Top