Create a drop-down list

  1. Select the cells where you want the list to appear.

  2. To open the Data Validation dialog, click Data > Data Validation.

    Where is it?

  3. On the Settings tab, in the Allow box, click List

  4. On the Source box, type a short list separated by commas. For example, Yes,No,Maybe.

  5. Click OK.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

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.