![how to make a drop down list in excel with multiple columns how to make a drop down list in excel with multiple columns](https://cdn.extendoffice.com/images/stories/doc-excel/multiple-level-drop-down-list/doc-multi-level-drop-down-list-17.png)
When we added Nigeria in row 21 and we checked the drop-down, we can see that Nigeria is included in the List. The auto-expand drop-down list is created and the last country is USA in row 20 In this video I show you to create a drop-down list in Excel that lets you select multiple items. Click inside the Source and deploy F3 (which opens the Paste Name).In cell F2, In the Data Tools group of the Data tab, click on Data Validation.In the Create Names from Selection, Top Row is fine.Change the ‘Allow:’ drop-down value to ‘List’ (Figure 6) Figure 6. On the Data tab, in the Data Tools group, click Data Validation. On the second sheet, create the following named ranges.
![how to make a drop down list in excel with multiple columns how to make a drop down list in excel with multiple columns](https://i.stack.imgur.com/uGnJX.png)
This will open the window shown in Figure 5. To create these dependent drop-down lists, execute the following steps. From the Data menu click the ‘Data Validation’ button (see Figure 4). Select the cell that will be holding the drop-down list. To create the auto-expand drop-down list in the old ways, the dataset must be formatted as an Excel Tables by pressing CTRL + T inside the data and click on OK in the Create Table intermediate dialogue box. Switch back to the worksheet where the form is beign creating. The Data is already formatted as an Excel Tables in both sheets Step 3: Now click on the Data tab from the top of the Excel window and then click on Data. Step 2: Now select any cell where you want to create the drop-down list for the courses.
![how to make a drop down list in excel with multiple columns how to make a drop down list in excel with multiple columns](https://www.xelplus.com/wp-content/uploads/2020/03/Dropdown-Demo.gif)
We have a simple Covid-19 dataset in the caption below. Converting a list to an Excel table make data sets accessible to style, manage (add or delete row and column) and perform multiple data summary functions. Follow the below steps to implement a dynamic chart linked with a drop-down menu in Excel: Step 1: Insert the data set into an Excel sheet in the cells as shown above. Kindly watch the video below and subscribe to the YouTube channel In this blog, we are going to look at the old school and the new school techniques of create auto-expand drop-down list in Excel.