Use List Box to create a drop down list with multiple checkboxesī: Name the cell which you will locate the selected itemsĬ: Insert a shape to help output the selected itemsĮasily create drop down list with checkboxes with an amazing toolĪs below screenshot shown, in current worksheet, all names in range A2:A11 will be the source data of the list box.
In this tutorial, we are going to show you two methods to create drop down list with multiple checkboxes in Excel.
Actually, you can’t create a list with multiple checkboxes with Data Validation. Many Excel users tend to create drop down list with multiple checkboxes in order to select multiple items from the list per time. How to create drop down list with multiple checkboxes in Excel?
