The next two sections of this tutorial will give you the VBA code to allow multiple selections in the drop-down list (with and without repetition). To enable this drop-down to allow us to make multiple selections, we need to add the VBA code in the back end. Now, cell C2 has a drop-down list which shows the items names in A2:A6.Īs of now, we have a drop-down list where you can select one item at a time (as shown below). In Source field, select the cells which have the items that you want in the drop down.In the Data Validation dialogue box, within the settings tab, select ‘List’ as Validation Criteria.Go to Data –> Data Tools –> Data Validation.Select the cell or range of cells where you want the drop-down list to appear (C2 in this example).Here are the steps to create a drop-down list in Excel: There are two parts to creating a drop-down list that allows multiple selections: So if you have any questions after reading this, please check out the FAQ section first. Since I get a lot of similar questions, I have decided to create an FAQ section at the end of this tutorial. All this is important for you to learn especially if you work in an office because you never know when your boss asks you to prepare one such drop-down list.This has been one of the most popular Excel tutorials on this site. Now that you are familiar with the steps you can prepare as many drop-down lists you want by following the same steps given above. Thus, you can see that creating a drop-down list in MS Excel is no big deal if you know the steps correctly. There, you have your drop-down list ready. Once you are done click on the ‘OK’ button.The next thing that you have to do is enter the name of the list that you have given in the box named as ‘Source.’.What you have to do here is click on the ‘Any Value’ and then choose the list.
Once you click on the said option a dialog box will appear on your screen.Next, go to the ‘Data validation’ button.Now go to the option ‘Data’ that you will notice at the top of the page.Similarly, you can choose any other cell that you want. Like for instance, in the picture, we have selected the cell B2. The next step is to select the cell in which you want to add the drop-down list.You have to write its name in the box as shown in the picture below. In this step, you have to select the entire list and give a name to it.It is advised that you write the list in alphabetically in ascending order as shown in the picture below. Now write down the list somewhere in the spreadsheet.First of all, open MS Excel on your computer or laptop.
All you have to do is follow the steps given below and you will be all ready with your drop-down list within no time. Steps To Create a Drop-Down List In MS ExcelĪ drop-down list allows you to select a choice from a given list without you having to type it out. To help you out we have listed the detailed steps to create a drop-down list in MS Excel. If you are one of them then we have got your back. However, the process to create a drop-down list may not be clear to many of the users. By doing this you can restrict a user from entering any other value and thus, force him/her to choose a value from the list given there. Creating a drop-down list is possible in MS Excel spreadsheet. A drop-down list is really helpful when it comes to restricting the number of choices for a selection in web forms, polls, and surveys. With the help of the drop-down list in MS Excel, you can greatly facilitate data entry.