In the source box, add new list.

How to add drop down list options in excel. Precede it with an equal sign. Web you aim to add a dropdown list where each item appears just once. In the data validation dialogue.

Edit, copy, delete, add or remove items without changing the data. On the ribbon, click the data tab, and click data validation. =unique (a2:a21) optionally, you can sort.

Select the data tools group from the data tab. Make sure the items are consecutive (no blank rows). Web to insert a drop down list in excel, you use the data validation feature.

Click data validation under the data tools section of the data tab. Web in the allowdropdown, select listfrom the options. In thesourceinput box, enter the name of your named range for the list source.

Select the cells that you want to contain the lists.