Drop Down Excel Deutsch. This article explains how to create a drop down list in excel that pulls data from a different worksheet. Create the drop down list select the cells in which you want the drop down list on the ribbon s data tab click data validation.
On the data tab in the data tools group click data validation. You can find and double click a saved excel file on your computer or open microsoft excel and create a new worksheet step 2 enter the list of values for your drop down in a column. 2 levels dependent drop down list option and then check.
2 levels dependent drop down list option and then check.
The data validation dialog box appears. However do not include the header cell. In source type my list name. Click ok button to close the dialog and all drop down lists in the selection will be removed.
