Learn how to create a drop down list in Excel in this step-by-step tutorial. We’ll firstly teach how to create a drop down list with a selection from the days of the week.
Then, we’ll also explain how to create a smaller drop down list with only two options: yes and no.
By the end of this tutorial you’ll know two simple ways to create drop down lists in Excel.
- Create a drop down list with the days of the week
- Create a simple yes/no drop down list
