Excel - how do I use drop down list to filter data

How can I use pull down lists to filter data. For instance I have a
spreadsheet of 100 different cars of various makes/models. I want to use
the first pull down menu to filter out all of the Chevrolets. The next pull
down will show the results of the first pull down. where I can select one.
Is this possible?

"Donna" wrote:
> How can I use pull down lists to filter data. For instance I have a
> spreadsheet of 100 different cars of various makes/models. I want to use
> the first pull down menu to filter out all of the Chevrolets. The next pull
> down will show the results of the first pull down. where I can select one.
> Is this possible?

Assume the car make descriptions are housed in col B,
label in B1, data from row2 down

Select the entire table, then
Click Data > Filter > Autofilter
Select "Custom" from the autofilter dropdown list in B1
Under "Show rows where",
Select "contains", then type in the box next to it: Chevrolet
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Max,

Thank you. How do I then use that pull down to limit the number of entries
in the 2nd pulldown to limit it to "Camaro's?

"Max" wrote:

> "Donna" wrote:
> > How can I use pull down lists to filter data. For instance I have a
> > spreadsheet of 100 different cars of various makes/models. I want to use
> > the first pull down menu to filter out all of the Chevrolets. The next pull
> > down will show the results of the first pull down. where I can select one.
> > Is this possible?
>
> Assume the car make descriptions are housed in col B,
> label in B1, data from row2 down
>
> Select the entire table, then
> Click Data > Filter > Autofilter
> Select "Custom" from the autofilter dropdown list in B1
> Under "Show rows where",
> Select "contains", then type in the box next to it: Chevrolet
> Click OK
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---

Hi Donna

Repeat the procedure Max gave you, but on the column containing the
Model type e.g. supposing Model is in column C then use the dropdown on
column C, select Custom>Contains> and type Camaro in the white pane

--
Regards

Roger Govier


"Donna" <[email protected]> wrote in message
news:[email protected]...
> Max,
>
> Thank you. How do I then use that pull down to limit the number of
> entries
> in the 2nd pulldown to limit it to "Camaro's?
>
> "Max" wrote:
>
>> "Donna" wrote:
>> > How can I use pull down lists to filter data. For instance I have
>> > a
>> > spreadsheet of 100 different cars of various makes/models. I want
>> > to use
>> > the first pull down menu to filter out all of the Chevrolets. The
>> > next pull
>> > down will show the results of the first pull down. where I can
>> > select one.
>> > Is this possible?
>>
>> Assume the car make descriptions are housed in col B,
>> label in B1, data from row2 down
>>
>> Select the entire table, then
>> Click Data > Filter > Autofilter
>> Select "Custom" from the autofilter dropdown list in B1
>> Under "Show rows where",
>> Select "contains", then type in the box next to it: Chevrolet
>> Click OK
>> --
>> Max
>> Singapore
>> http://savefile.com/projects/236895
>> xdemechanik
>> ---