Table of contents
Welcome to Excel
Welcome to Excel

Create a drop-down list

Your browser does not support video.

Try it!

Help people work more efficiently in worksheets by using drop-down lists in cells where they can pick an item from a list you create.

  1. Select where you want the drop-down to appear.

  2. Select Data > Data Validation.

  3. Choose List.

  4. Select the Source button.

  5. Select items to appear in the drop-down and press Enter.

  6. Select OK.

  7. Select the drop-down arrow to select items from your drop-down list.

Want more?

Merge and unmerge cells

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!