Filters & Drop Down Lists

[Darth_Williams]

Good afternoon all,

I have created a spreadsheet that uses drop down lists to control the data that is entered. A problem that I have encountered though is that I can not now apply filters to my headers.

Does anyone know of a work around for this or is it a by product of using drop down lists?

Thanks

 

[Darth_Williams]

That's right. I have taken sheet protection off completely and still can't get filters to work. The odd thing is that filters will work on all the columns that do not have drop down lists in them, which is of no use to me at all

 

[Fluff]

If you select the header row & add the autofiler, do you get the filter arrow for those columns with the dropdowns?

 

[Darth_Williams]

Solved it. Two of the columns had been formatted as a table and not the whole range. I've just undone that and bingo, it's working as it should. Thank you very much for all of your assistance.

 

[Fluff]

Glad you were able to solve it & thanks for the feedback