Delete Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Do an autofilter and look for CONTAINS Total. Delete the rows you want.
 
Easiest would be to sort and delete or data>filter>autofilter>delete or a
looping macro
 
Try autofilter? Custom/ does not equal/ Total, then Delete row, should
leave the ones with Total.
Save the existing file first though, just to be on the safe side.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting rows containing zeros 2
Excel Help to copy information from one row at a time to another sheet 1
Sort by Every Other Row? 0
wrap text multiple column with format 1
macro help on mid 3
Deleting lines that use them for formulas 4
writing a sort macro 2
I can't see Grand total rows even though the option's switched on 2

Back
Top