View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Excel 2007 spreadsheet - blank rows

Pick a typical column, say column A. Switch on AutoFilter and select blanks.
Then delete the visible rows.
--
Gary''s Student - gsnu200905


"pc4n6" wrote:

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!