I have seen a couple of times Excelsheets where drop down filters exist in e.g. cell C2
for the range of cells from C3:C27.

So when in den cells C3:C27 value appear like

aaa
bbb
ccc
aaa

bbb
bbb
aaa
....
ccc

and I select the drop down menu in C2 then all available values should appear
when I select then "aaa" only those rows should remain which contain value "aaa".

How do I achieve such a row filtering?

Claudia

In xl2003 menus:

Select C2:C27
Data|Filter|Autofilter

You may want to select more columns so that you could filter them, too.

Claudia d'Amato wrote:
>
> I have seen a couple of times Excelsheets where drop down filters exist in e.g. cell C2
> for the range of cells from C3:C27.
>
> So when in den cells C3:C27 value appear like
>
> aaa
> bbb
> ccc
> aaa
>
> bbb
> bbb
> aaa
> ...
> ccc
>
> and I select the drop down menu in C2 then all available values should appear
> when I select then "aaa" only those rows should remain which contain value "aaa".
>
> How do I achieve such a row filtering?
>
> Claudia

--

Dave Peterson

I think if you highlight the row containing the titles to be filtered on, in
your example, highlight row C. Then select Data, Filter, Autofilter. I
think this will give you what you are looking for if I understood your
question.

"Claudia d'Amato" wrote:

> I have seen a couple of times Excelsheets where drop down filters exist in e.g. cell C2
> for the range of cells from C3:C27.
>
> So when in den cells C3:C27 value appear like
>
> aaa
> bbb
> ccc
> aaa
>
> bbb
> bbb
> aaa
> ....
> ccc
>
> and I select the drop down menu in C2 then all available values should appear
> when I select then "aaa" only those rows should remain which contain value "aaa".
>
> How do I achieve such a row filtering?
>
> Claudia
>
>