Find and Delete Rows

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

Guest

I have about 4700 rows I need to delete. I can find them, but I don't know
how to mass delete the rows. How can I use Find/Replace to delete the rows
in the results of my find?
 
You can't use Find/Replace to delete rows directly.

However, you can use that feature to replace the text with a specific
character or string (ie the replace would be something like ZZZDelete).
Then you can sort the entire dataset and all of the rows to be deleted will
be grouped together. Select all of them and delete.
 
If they have a common demonitor then use data>filter>autofilter>filter the
list and delete.
 
Back
Top