Now, i can either type the name or i can choose the name.

How to add data in drop down list in excel. Web you aim to add a dropdown list where each item appears just once. =unique (a2:a21) optionally, you can sort. Web select this range, then click in the name box on the left hand side of the formula bar.

Select the cells that you want to contain the lists. On the ribbon, click the data tab, and click data validation. In the data validation dialog.

Web with the two named formulas in place, you set up data validation in the usual way ( data tab > data validation ). Select the data tools group from the data tab. Select data validation to open the data validation dialog box.

The steps slightly vary depending on whether the source items are in a regular range,. Web on the data tab, in the sort & filter group, click advanced. On the ribbon, click data > data validation.

Web to insert a drop down list in excel, you use the data validation feature. Select the range of cells, click copy to another location,. Enter a name, for example choices, and press enter.

Let's say that the cell. To extract the unique items, use this formula: On the second sheet, create the following named ranges.