Hi, I am hoping to make a database of articles from car magazines in order to find any relevant information quickly, each row would consist of the following sample info;

MAKE MODEL ARTICLE ISSUE PAGE No

FORD ESCORT ENGINE JUNE 07 25

ETC, ETC.

Eventually this list will consist of several hundred rows. The problem I have is that when searching for an item, eg " ESCORT " excel will highlight all mention of " ESCORT" but will still show the complete database, and I have to scroll down the whole list.

Is there a way for excel to show only the relevant rows that contain the search word.

Thanks, John