Optionally, you can check the box to.
How to add drop down list i excel. On the first sheet, select cell b1. To extract the unique items, use this formula: Web to insert a drop down list in excel, you use the data validation feature.
Highlight the cells that you want the list to be available in. You can add or delete items from your drop. Go to the data tab and click on.
=unique (a2:a21) optionally, you can sort. Web select a cell in which you want the dropdown to appear (d3 in our case). Web you aim to add a dropdown list where each item appears just once.
I usually like to put this on a separate sheet labeled data or something similar. Which menu in the ribbon can create a dropdown list? A data validation popup will appear after you click on data validation.
Web selected cells to add to drop down list. Select the data tools group from the data tab. On the data tab, in the data tools group, click data validation.
On the second sheet, create the following named ranges. This allows you to enter data into a specific cell of a. In the data validation dialog.