Instruction
1
In a table or list, select the cells containing the data you want to put in a drop-down list. In the menu select "Insert" - "Name" "Assign". Further, in the requested field, type a name for the selected range and click "OK".
How to make a dropdown list in Excel
2
In the worksheet, select the cell to set the drop-down list. In the menu open "Data" - "Validation". After that navigate to new window in the tab "Settings" in the dialog field "data Type" insert the string "List". At the same time in the same window will appear the "Source". Enter the symbol "=" and the name of the selected range, which was specified cells with the data. To apply settings press "Enter" or "OK". This is the most simple variant of the drop-down list.
How to make a dropdown list in Excel
3
At the same time in the same window will appear the "Source". Enter the symbol "=" and the name of the selected range, which was specified cells with the data. To apply your selections, click "Enter" or "OK". This is the most simple variant of the drop-down list.
How to make a dropdown list in Excel
4
In Excel there is no way to set the drop-down list with a more complex design. To do this, use the control called "list box", inserted into the Excel worksheet. To install it, open the menu "View" then "toolbars" and "Forms".
How to make a dropdown list in Excel
5
Click on the opened panel controls icon combo box" - this is a drop-down list. Draw with the mouse a rectangle in the form fields. Highlight, right-click the drawn list, and specify the Format of the object...".
6
In the dialog box in the "create a list range set the desired range of cells. To do this, the mouse select the cells which should be in the drop-down menu of Excel. In the field "cell Link box, select the location number to output the sequence number of the item selected in the list. Specify the number of rows in a generated list. The "OK" button will apply all settings, and the list is ready to use.
How to make a dropdown list in Excel