In the source box, add new list.

How to add priority drop down list in excel. Select new rule, and then select format only cells that. Go to data > validation > settings tab (see image below) select list from the allow:. Create a list of data and select a range that you want to put the drop down list values into.

Web to insert a drop down list in excel, you use the data validation feature. Web it’s easy and we’ll show you how. Simply click the arrow and select an option.

Enter a name, for example choices, and press enter. Web on the ribbon, click data > data validation. Then, customize the list using the data validation options.

On the data tab, in the data tools group, click data validation. Web select this range, then click in the name box on the left hand side of the formula bar. Select the “new” option in the “name manager”.

The steps slightly vary depending on whether the source items are in a regular range,. In this case, i select range a2:a6 to put the drop. In the data validation dialog.

Web the steps to create named ranges are listed as follows: Let's say that the cell.