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