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…