delete blank rows?

[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,

 

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP

 

[liu]

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

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!

 

[Bernie Deitrick]

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.

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!

 

[liu]

Thank you so much. The second one works well for me.

Best regards,