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?

1 thought on “How to Create a Drop Down List in Excel (Step-by-Step)”

  1. Y’know, this would be a lot more helpful with step by step instructions written out. Some of us have lousy internet speed or work blocks all Youtube content.

Leave a Comment

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