Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an excel file where I want to set up data validation with dependent lists. I have set up the named ranges. I have data validation set up in the first column. However when I go to apply the dependent list in column 2 only the first cell of the column works properly. I have tried the format painter, fill down, highlighting an entire column before applying the dependent list validation... nothing works. Any idea of what I am doing wrong here?

share|improve this question
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.