search tool?

[Craig]

I have a very simple spreadsheet listing CD's, the list is so large now it
can take an age scrolling through it to find a particular CD.
Is it possible to add some kind of search tool to the spreadsheet for
finding a particular CD, or is there a website that could take me through
step by step on how to do this, listing alphabetical is not an option.
I would class myself as beginner level, sorry

 

[Dave Peterson]

If your data is in nice columns (one field per column), then you may want to
select your range and do Data|Filter|Autofilter.

If you click on one of the dropdown arrows, you'll see a list of all the unique
entries in that column (actually, excel stops at 1000 entries).

You can even choose Custom, then Contains to match all the cells that contain a
certain string.

Debra Dalgleish has a bunch of tips at:
http://www.contextures.com/xlautofilter01.html

And remember that you can always do Edit|Find (or ctrl-F) to find stuff in your
worksheet.

 

[Craig]

Thanks for that, just what I need

If your data is in nice columns (one field per column), then you may want to
select your range and do Data|Filter|Autofilter.

If you click on one of the dropdown arrows, you'll see a list of all the unique
entries in that column (actually, excel stops at 1000 entries).

You can even choose Custom, then Contains to match all the cells that contain a
certain string.

Debra Dalgleish has a bunch of tips at:
http://www.contextures.com/xlautofilter01.html

And remember that you can always do Edit|Find (or ctrl-F) to find stuff in your
worksheet.