View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MH
 
Posts: n/a
Default Deleting all but one blank row

You're not able to add a row under "insert"?

"RealGomer" wrote:

I have a file created by another program that inserts six blank rows after
each row of data. The exported format is Excel 8.0 Extended (whatever that
means). I found several really helpful suggestions how to delete all of the
blankrows. The one to use the Go To Special command seems to be the easiest.
Unfortunately, I want to keep one blank row as a divder between each data
row. Any suggestions?
--
I know enuff to be dangerous.