Drop Down Excel Deutsch. After free installing kutools for excel please do as below. Select the cell with the drop down list.
Click ok button to close the dialog and all drop down lists in the selection will be removed. For example if you want your drop down list to include new york boston and los angeles you can type new york in cell a1 boston in cell a2 and los. Firstly place the original data as below screenshot shown 2.
For example if you want your drop down list to include new york boston and los angeles you can type new york in cell a1 boston in cell a2 and los.
Select the data click kutools drop down list dynamic drop down list. Step 1 open the excel spreadsheet file you want to edit. Now test the drop down list and it should show the short list of available employees instead of the full list. Select the data click kutools drop down list dynamic drop down list.
