filers in more than 1 cell

in excel i have a coloum F and it starts from F10 to F165 now how do i appile
filters to them all

i want to be able to use just use the drop down for the user to select what
departmet they need and in the drop down their is going to be a list of 17
departments

any ideas

Gav123
Thu May 08 09:29:03 CDT 2008

Hi Kevin,

This site should help you..

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

Hope this helps,

Gav.

"kevin" wrote:

> in excel i have a coloum F and it starts from F10 to F165 now how do i appile
> filters to them all
>
> i want to be able to use just use the drop down for the user to select what
> departmet they need and in the drop down their is going to be a list of 17
> departments
>
> any ideas