It is very convenient to work with various tables for calculations in Microsoft Excel. On their basis, you can create reports, build diagrams of various types and graphs. When working with data, one of the auxiliary elements in Excel is a drop-down list. With the help of this element, the user can select a value in one field from a number of specified, uniform data. The drop-down list is installed using built-in Excel tools. You can set the dropdown list by assigning a special type to the data range or by using a control.
Instructions
Step 1
In the table or list, select the cells with the data that you want to place in the drop-down list. In the menu, select "Insert" - "Name" - "Assign". Next, in the requested field, enter a name for the selected range and click "OK".
Step 2
In the required place on the sheet, select a cell to specify the drop-down list. In the menu, open the items "Data" - "Check". Then go to the "Parameters" tab in a new window and set the "List" line in the "Data type" field that opens. In this case, the "Source" field will appear in the same window. Enter the symbol "=" in it and the name of the selected range that was assigned to the cells with data. Press “Enter” or “Ok” to apply the parameters. This is a variant of the simplest dropdown list.
Step 3
In this case, the "Source" field will appear in the same window. Enter the symbol "=" in it and the name of the selected range that was assigned to the cells with data. To apply the set parameters, press "Enter" or "Ok". This is a variant of the simplest dropdown list.
Step 4
Excel provides the ability to define a more complex drop-down list. To do this, use a control called "combo box" inserted into the Excel worksheet. To install it, open the menu items "View", then "Toolbars" and the sub-item "Forms".
Step 5
Select the "combo box" icon on the control panel that opens - this is the drop-down list. Draw a box-shaped rectangle with the mouse. Select the drawn list with the right mouse button and select the "Format Object …" command.
Step 6
In the dialog box that appears, in the "Generate list by range" field, specify the desired range of cells. To do this, use the mouse to select the cells that should be included in this drop-down list in Excel. In the "Link to cell" field, set the cell number to display the ordinal number of the item selected in the list. Set the required number of lines for the created list. The "Ok" button will apply all the set parameters, and the list is ready to use.
