Drop down in excel - create smart drop down lists in excel (with data validation).

the data validation editor will close and you'll be returned to the cell that previously contained a drop down list where you'll now see that the excel drop down list has been removed.
finally we get searchable drop down lists in microsoft excel without writing complex formulas.
after you're done putting information into the sheet containing your list values go back to the sheet where you want to actually create the drop down lists in excel and then click inside of one of the cells where you want to add an excel drop down list to select that cell...
clicking that drop down arrow will display the items you choose to include in your excel drop down list.

- how to create a simple excel drop down list: . in this example you can see i've got a form where i've got a couple of questions that i want to add excel drop down lists for so i can control the options people can input as answers...
quickly learn how to make a drop down list in excel or add other data validation checks.

свернуть