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:
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.
0 kommentar(er)
