extra rows

  • Thread starter Thread starter Chi Huynh
  • Start date Start date
C

Chi Huynh

when i copy a file from Microsoft Word and paste the
file to Excel, there are empty rows which are between the
records. How can I delete these empty rows so that I will
have continous list?
Example:

1. 2562
2. nothing
3. 1212
4. nothing
5. 4545
6. nothing
..... so on like that.

I like my list : 2562
1212
4545
Thank you
Chi
 
Is there truly nothing in the cells? If so, then select the entire area of data and blanks, do
Edit / Go To / Special / Blanks, and then do Edit / Delete / Entire row.
 
Back
Top