Forum Discussion
Solved
Deleting rows that contain specific content
Copying records from a source into excel, each record copies over as either 2 or 3 lines. Nearly every record contains a unique line with the word "search" in it. I don't need those lines in my spr...
You can do this without programming:
- On the Home tab of the ribbon, in the Sort & Filter group, turn on Filter.
- From the filter dropdown in the relevant column, select Text Filters > Contains...
- Enter Search in the box, then click OK.
- You should now see only the rows containing Search.
- Delete those rows.
- Turn off the filter.
Just wanted to add to this for others that come here looking for a good solution...
If you have an enormous number of rows after using the Auto Filter to view the filtered data, selecting all will delete hidden rows as well.
To delete just the rows selected by the filter use the Find&Select - GoTo Special option and choose "Visible cells only", then delete rows will only delete the rows selected by the filter.
Hey, Omni, many thanks. You just saved me a couple of hours hunting for a solution. Upvoted. Also very nice to learn about that "Special" option.