Thread: deleting rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
CB CB is offline
external usenet poster
 
Posts: 97
Default deleting rows

i have200 rows in sheet- there are lets say 100 rows the title shipping
i have another 100 rows with the title payments.
they are in mixed in and not grouped together otherwise i could highlight
them all together and delete-how do i delete all the ones that say shipping
without clicking on each individual row. I am on excel 2007 trial