Singling out searched cells

[Lycean]

I'm creating a customer database, and I would like to be able to search for
values and ONLY show those that match. For instance, if I search for Apples,
I only get the lines with cells containing "Apples". Right now, with ctrl + F
it only shows me where they are in the document, I need it to acutally
isolate the rows.

 

[Gord Dibben]

If all instances of Apples would be in one column use
Data>Filter>Autofilter.

If more complex than that post back with some details.

Could Apples be in several different columns?

Could Apples appear twice in the same row?


Gord Dibben MS Excel MVP