On a Google Sheet, I want to have a dropdown list of options to choose from. However, these options are split into different sections and so I would need to select multiple sets of data. I can get the dropdown to work if I just do


But this is a problem because then the dropdown includes some titles which I don't want as options. However, If I try to do something like

A3:A14 A19:A23

It doesn't work. So Is there a way I can get a dropdown to use multiple sets of data?


1 Answer 1


This used not to be possible, and I suspect still isn't. A workaround of sorts may be to enter:


in a spare area, and then apply whatever range that occupies to the list range for your dropdown.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.