Thread: help delete blank rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming
Cletus Stripling Cletus Stripling is offline
external usenet poster
  
Posts: 3
Default help delete blank rows
I have a spreadsheet with a blank row between each row of good data. What is
the best way to quickly eliminate all these blanks?

Could this be easily done?

Sampel Data

Col A
John
blank
Sue
blank
*
*
*
Kim
blank
Sally


Reply With QuoteReply With Quote