Excel 2007 spreadsheet - blank rows

[pc4n6]

I imported telephone records (text file) into excel and when it was brought
over, every other row is empty/blank. How do I delete every other row of
this spreadsheet? Want to thank you all in advance...this is such a great
resource and I appreciate all the help and quick responses.

Thank you!

 

[Gary''s Student]

Pick a typical column, say column A. Switch on AutoFilter and select blanks.
Then delete the visible rows.

 

[tom]

Hello can you help me figure out how or what the sign is for subtract in
formatting a column that has ex. a4:a10 and then i want to subtract e4???

Thanks