Forum Discussion
Depending dropdown in excel online
Hello, I hope to get some help here. Does anyone know how to create a dependent drop down menu in Excel On Line ? This set up should be replicated in multiple rows I have tried with the...
In my experience, Data Validation (which is what I assume you mean by Dropdowns) only works with spreadsheet ranges. Most professional Excel programmers will carry a Worksheet around - sometimes hidden from view - for only such purposes. Try to create a new Worksheet, insert your SPILL somewhere to create the dynamic list, give that SPILL a name and use that name in your Data Validation. Your best chance, really.