Drop-down not functional

Occasional Visitor

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?

2 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.