Excel Drop Down List Tutorial

Published: 02 January 2020
on channel: Kevin Stratvert
987,614
11k

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

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.

As full-disclosure, I work at Microsoft as a full-time employee.

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

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

Microsoft support article on creating drop down lists: https://support.office.com/en-us/arti...


On this page of the site you can watch the video online Excel Drop Down List Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Kevin Stratvert 02 January 2020, share the link with friends and acquaintances, this video has already been watched 987,614 times on youtube and it was liked by 11 thousand viewers. Enjoy your viewing!