Step 4: Now, click on any cell from the range to which you have applied the dropdown list. In the image below you can see that I have added a name ‘ Jhona’ in the list separated by a comma. If you want to add an item to the list add it by separating with a comma or if you want to delete an item, you can delete it with the backspace or delete button. In the Source box edit the list you have created earlier. From the provided options click on ‘ List’. Under the Setting tab, you have an Al low dropdown list. Step 3: Data Validation dialog box will open. Step 2: Then click on Data Validation from the Data Tools group in the Data tab. So, select the entire range of cells to which you have applied the dropdown list. Step 1: Select the range of cells to which you have applied the dropdown list, as if you will select only one cell from the applied range then the modification will only be applicable to the selected cell only. Steps to Edit Dropdown List in Excel 2016: Edit Dropdown List based on Named Range of Cells.Edit Dropdown List based on Range of Cells.We will edit the dropdown list using the three methods as shown below: In this section, we will discuss the methods to edit the dropdown list. if you want to add more items to the drop-down list or you want to delete the items from the drop-down list you can do it with few pretty simple steps. In case, you need to edit dropdown list i.e. In our earlier post, we have discussed the methods to create the drop-down list.

Insert drop down menu excel 2016