How to remove lines from a document that do NOT contain a specific value?

Question

excel

I have a large excel document. You need to remove rows from the table that do not contain a specific value. The problem is that this value can be in different columns, moreover, a cell can contain not only this value, that is, this value as part of a phrase. Searching the document itself finds all of these lines. But transferring them manually is a horror. There are more than 11,000 rows in the table, and more than two hundred rows with the required value. How to be? Maybe someone solved similar problems? share your experience.

Answer 1

Apply conditional formatting to the sheet for the phrase you are looking for. (I was looking for the symbol "1" for the searched phrase)
Next, use filters to remove all the lines that need to be saved. (in the column, click on the filter - filter by color - no fill. Repeat for each column.) (for the conditional formatting option with a fill)
As a result, we get
Delete the rest.
PS Of course, you can also use a macro, but if you need it quickly, it will work.