How to Make a Drop Down List in Excel – Tutorial

We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)

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.