How to Make a Drop Down List in Excel – Tutorial

Video is ready, Click Here to View ×


Excel tutorial on how to make a drop down list in Excel. We’ll walk through an example of how to create and then edit a dropdown list in an Excel spreadsheet.

You’ll also see how you can add a custom message to the items in your drop down list and, if you’d like, you can also edit the error alert displayed if someone tries to type a value that is not part of your drop down list.

Lastly, one of the things I love about Excel is its ability to automate work. One of the books that helped me most while I was learning how to use Macros and automate my work was The Little VBA Book.

If you’d like to try this book, consider purchasing it using my Amazon Affiliate link – you’ll get a great learning tool and help support this channel:

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out ?

And make sure you’re subscribed so you can…

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.