How to Create a Drop Down List in Excel (Step-by-Step)

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.

1. Create a drop down list with the days of the week
2. Create a simple yes/no drop down list

Prefer the Drop Down List Video Instructions?