Drop-down not functional

New Contributor

What would cause a drop-down to not function? I use drop-downs all the time, and haven't had this happen:

Data validation applied to one column on a worksheet. Configured as List, with Source being a named range on another sheet. Yet no drop-down appears.

What am I missing?

5 Replies


Exactly what you are missing is not possible to comprehend for someone who wants to help.
If I may recommend, attach a file (without sensitive data) and explain your topic based on this file.

It is advantageous if the version of Excel, operating system and storage medium are known.

Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5

Here is a link that might help you by comparing it to your dropdown.

How to make a dynamic dependent dropdown list in Excel an easy way

Standard disclaimer: none Microsoft website


Thank you for your patience and understanding


Hope I could help you with these information / links.



I know I don't know anything (Socrates)

Hi @Schmacker 


I agree with @NikolinoDE , a sample file would make things easier for us to help.

Apart from that, you could check if you have ticked this option:


Without, the dropdown-arrow would not appear.

I don't see how to attach my file to this discussion.
best response confirmed by Schmacker (New Contributor)

Hi @Schmacker 


the solution for this strange behaviour is a setting in the advanced Excel options. For whatever reason, this flag "For objects, show:" is set to "Nothing (hide objects)" in your workbook.


Once you set it to "All", the dropdwon arrows will re-appear.



Kind regards,

Wow, that was too easy, after the trouble it put me through. Thanks!