lookup text in a list of books

[mypig7]

I have a list of book titles in column A

I wish to type a word in an empty cell (B1)
and then search the list of books and show the ones which contain the word in cell B1 in their title.

What's the best way?

 

[al_b_cnu]

Hi,

How about using Autofilter - highlight the column, Data / Filter / Autofilter

Then use the custom filter

 

[mypig7]

many thanks