Thread: Delete Rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Delete Rows

Do an autofilter and look for CONTAINS Total. Delete the rows you want.
--
HTH,
Barb Reinhardt



"RMT" wrote:

How do I delete several rows that don't have the word total. I want to keep
the rows with word total in column A.
Thanks