Like I have added a new name ‘ Jhona‘ to the list which is in Sheet2 and I have applied the dropdown list in Sheet 4 of the same document. Step 1: Come to the range of cells where you have created the list for the drop-down box it can also be in a separate sheet. Instead of manually adding the items to list separated by comma you can simply create a list of items in excel sheet and select that range of cells in the Source box of Data Validation dialog box. Click the dropdown arrow, scroll down and see that the item you have added is appearing in the list or the item you have deleted has vanished from the list.Įdit Dropdown List based on Range of Cells 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:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |