In this article, we are going to learn how to edit Excel drop down list if we have already drop down list.
Let us take an example:
We have dropdown list in a sheet, and in which cell we have dropdown list, we want to change the list of the cells.
For Example:- In cell F6, we have dropdown list to main category of Week names, Month names and Serial Number and cell G6 contains the sub category to each main category. Now we want to change the main category in Fruit names and Vegetable names.
To edit the dropdown list, follow the below given steps:-
- Select the cell F6.
- Go to Data tab > Data Tools > Data Validation.
- Or use ALT + D + L shortcut keys for Data Validation
- In Settings group > Allow > List > Source.
- Change the old source with the new source name, and click on OK.
- Select the cell G6.
- Again open the Data Validation dialog box.
- Click on OK.
When we will select the fruit name from the list in cell G6, we will have only fruits name as well with Vegetable names.
This is the way we can edit in the dropdown list and change the list selection.
Below you can find more example:-
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at email@example.com