Learn how to create drop down lists in Excel in this step-by-step tutorial. By using drop-down lists, you can help people work more efficiently in worksheets by allowing people to pick an item from a list that you create.
In this video, I show you how to create a pre-defined drop-down list and a drop-down list based on another table. Additionally, I show you how to show an input message to provide users with a tool tip. Lastly, I also show how to display a warning message when users enter an incorrect value.
If you've ever used Microsoft Excel for gathering information through a form or a survey, you know that it can be difficult to control what people enter. One option for controlling the information people enter is to create drop down lists that limit people to choosing from a list of options you provide. Making a drop down list in Excel only takes a few minutes, and will save you a lot of time in cleaning up non-standardized information.
![](https://s2.save4k.ru/pic/gFKauHJ3Jow/maxresdefault.jpg)