This means that the user can select the cell and then deselect.

How to add and remove drop down list in excel. To do this, i’m going to select a cell and under the data tab, click on. Web on the data tab, in the sort & filter group, click advanced. To extract the unique items, use this formula:

Then, customize the list using the data validation options. =unique (a2:a21) optionally, you can sort. On the settings tab, click clear all.

Web creating the drop down now that my list has been created, i can set up the actual drop down. You can add or delete items from your drop. Please note that there’s more than one way to create a d.

On the data tab, in the data tools group, click data validation. This will open the code window for that. Web it can be in the same worksheet or another one.

Web everything until now works great now with all that information i would like to add the when i choose a name on the drop down menu on page pag1 also on that. Web click data > data validation.