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:-
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
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.