Thread: Delete all blank rows...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lori Lori is offline
external usenet poster
  
Posts: 340
Default Delete all blank rows...
Try adding another column which counts blanks (e.g. =COUNTBLANK(A2:G2)
in column H). Then apply DataFilterAutoFilter selecting the largest
value in the list and delete all rows.

Reply With QuoteReply With Quote