Filters & Drop Down Lists

Darth_Williams

New Member
Joined
Oct 15, 2015
Messages
25
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
 
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
 
Upvote 0

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
If you select the header row & add the autofiler, do you get the filter arrow for those columns with the dropdowns?
 
Upvote 0
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.
 
Upvote 0
Glad you were able to solve it & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,287
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top