How To Delete the Empty Rows

[Han]

X
..
..
Y
..
..
..
Z
..
..
..
A
..
..
B

Dear Sir or Madam

Could you show me how to delete the empty rows and keep the colum in
the same order(As below)using the Excel Function?

X
Y
Z
A
B
Thanks for your help!

 

[Dave Peterson]

If the cells are really empty, you could:
Select the column
Edit|goto (in xl2003 menus) or F5 or ctrl-g
Click Special
Then Blanks

Then rightclick on one of the selected cells and choose Delete (and entire
row--I think that's what you want).

 

[Jordon]

You could insert a column, number them from 1 down to as many
rows as you have, sort by the column with the letters, delete
the blank ones and resort by the new column with the numbers.

 

[Han]

Thanks for your help!

You could insert a column, number them from 1 down to as many
rows as you have, sort by the column with the letters, delete
the blank ones and resort by the new column with the numbers.







- Show quoted text -