Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com'>https://kevinstratvert.thinkific.com

Learn how to create drop down lists in Excel in this stepbystep tutorial. By using dropdown 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 predefined dropdown list and a dropdown 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.

As fulldisclosure, I work at Microsoft as a fulltime employee.

Watch more Excel tutorial videos:    • ❎ How to use Excel  

Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com'>https://kevinstratvert.thinkific.com

Microsoft support article on creating drop down lists: https://support.office.com/enus/arti...