Simply click the arrow and select an option.

How to add priority drop down list in excel. Then, customize the list using the data validation options. The steps slightly vary depending on whether the source items are in a regular range,. Create a list of data and select a range that you want to put the drop down list values into.

Web the steps to create named ranges are listed as follows: Go to data > validation > settings tab (see image below) select list from the allow:. Web select this range, then click in the name box on the left hand side of the formula bar.

In the data validation dialog. Web select a cell in which you want the dropdown to appear (d3 in our case). Web to insert a drop down list in excel, you use the data validation feature.

Select new rule, and then select format only cells that. In this case, i select range a2:a6 to put the drop. Let's say that the cell.

In the source box, add new list. On the data tab, in the data tools group, click data validation. Enter a name, for example choices, and press enter.

Web on the ribbon, click data > data validation. In the dialog, set allow to list.