Excel 2007 spreadsheet - blank rows

  • Thread starter Thread starter pc4n6
  • Start date Start date
P

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!
 
Pick a typical column, say column A. Switch on AutoFilter and select blanks.
Then delete the visible rows.
 
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
 
Back
Top