On Oct 21, 4:13*pm, James wrote:
Data / Filter/ Auto Filter

Use the drop down table at the top of the column , use the Custom option,
Use the drop down table and use Contains and type “Apple”



"KalyanS" wrote:
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.
.

Thanks James. It worked perfectly.