How To Delete the Empty Rows

  • Thread starter Thread starter Han
  • Start date Start date
H

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!
 
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).
 
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.
 
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 -
Click to expand...
 
Back
Top