Find and Delete Rows

C

Carlton A. Barlow

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?
 
P

Paul Corrado

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.
 
D

Don Guillett

If they have a common demonitor then use data>filter>autofilter>filter the
list and delete.
 
Top