Forum Discussion
multi-select drop-down list
I would like to know if Excel supports the ability for a drop-down list to be multi-select. So for example, I would like a load a list of States into a drop-down list and allow the user to select mu...
Hi @BBary
Best to my knowledge Dropdown list the solution we have at the moment to handle this scenario.. I know making name ranges it’s quite length job..
However if you have Microsoft365 (Office365) the you can trying doing the same stuff with XLOOKUP & Excel Tables which much easies with less efforts
Check out the blog might be helpful https://excelexciting.com/how-to-make-dependent-dropdown-list-with-xlookup/
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
Best to my knowledge Dropdown list the solution we have at the moment to handle this scenario.. I know making name ranges it’s quite length job..
However if you have Microsoft365 (Office365) the you can trying doing the same stuff with XLOOKUP & Excel Tables which much easies with less efforts
Check out the blog might be helpful https://excelexciting.com/how-to-make-dependent-dropdown-list-with-xlookup/
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
ExcelExciting thanks for the suggestion. XLOOKUP doesn't help me accomplish what I was looking for, but I did learn something new with the suggestion and can see using that capability in the future. Thanks.
