Welcome to Excel

Create a drop-down list

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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

Discover more courses like this at LinkedIn Learning

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.