Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have managed to do a conditional drop down list from another list – however I now can't seem to copy it down the 1000 rows I need it to work on.

For example, in column A the user would select either:


Then in column B, the drop down list would be conditional upon what was selected in A. So if the user selected Fruits, the drop down list in B would be: Apples, Peaches etc. Or if the user selected Veggies in column A's list, the list in column B would be: Corn, Beans etc.

I did the formula and I have:


in the Validation tab etc.

The issue is: I have 1000 rows going down, and I don't know how to copy it all the way down, as when I do it shows the same options.

share|improve this question

Apply the validation rule =INDIRECT($A1) to column B down to B1000. Removing the fixed row reference will resolve the problem.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .