ways to search for data...

[Guest]

I have my excel as a database with cities, names, addresses, emails, etc. I
was wondering if there is any way to search on excel to pull up all columns
of a certain city. EX. Say i wanted to find out everyone in my database who
lives in cleveland, and i want ONLY all cleveland contacts to show up, is
there a way to do that? For now, i go to find, and type in cleveland, but
that still shows everyone else on the list (and highlights the cleveland
ones). I would like it to show only every cleveland contact. Any help?

 

[Norman Jones]

Hi Rocker,

This seems an ideal candidate for AutoFilter.

If you are not familiar with AutoFilter, look at Debra Dalgleish's tutorial:

http://www.contextures.com/xlautofilter01.html