delete blank rows?

  • Thread starter Thread starter cpliu
  • Start date Start date
C

cpliu

How do you delete blank rows and align all the cells to the top?

The only close one I can find is Remove Duplicates in Office 2007, but
I happen to have some data of the same string. They get removed too.

Thanks for the help,
 
Select all you cells and sort - the blank rows will be moved to the bottom.

HTH,
Bernie
MS Excel MVP
 
Select all you cells and sort - the blank rows will be moved to the bottom.
Click to expand...

Thanks for the answer. I can't sort though. It has to be in the
currrent order but only deleting the extra rows between items.

Any other way?

THANKS!
 
Sure, lots of ways:

1) Use a helper column filled with 1,2,3, etc. then sort based on another
column with the blanks, then change your selection and sort based on the
helper column.

2) Select a column, use Edit / Go to.... Special Blanks, OK, then Edit /
Delete / Entire row, OK.

3) Use a macro.

HTH,
Bernie
MS Excel MVP


Select all you cells and sort - the blank rows will be moved to the
bottom.
Click to expand...

Thanks for the answer. I can't sort though. It has to be in the
currrent order but only deleting the extra rows between items.

Any other way?

THANKS!
 
Back
Top