Select your data range (including all the rows & columns you want to
consider).
Data/ Filter/ Autofilter
Choose the column by which you want to filter/ In the Autofilter criteria,
select "contains" apple.
--
David Biddulph

"KalyanS" wrote in message
...
There are fifty lines in my spreadsheet. I want to filter this to see
only the lines that have "apple" in them (there are about 10 lines
with "apple"). How do I do that?

I am using Excel 2003 if it helps in any way.