via https://youtu.be/1XaqvTTgaY8

In this video, I show you two ways to create a dropdown list in Excel. Both methods use the data validation tool on the data tab and we select “list” from the allow field.

In the first method, we enter each item we want on the dropdown list in the source field, separated by a comma (spaces are not required, but may make it easier to read).

In the second method, we create the list on another sheet, name the selection and enter that name preceded by an equals sign in the source field.

  • Click on the Data tab
    Click on Data Validation
    In the validation criteria, choose Allow: List

Method 1: best for shorter lists

  • Source: Enter dropdown data separated by commas (i.e. XS, SM, MED, LG, XL, 2XL, 3XL)

Method 2: best for longer lists (starts around 2:01)

  • Source: create a list with 1 item per row, highlight the row & name the selection, enter the selection as the source (i.e. =shirt_sizes)

Don’t forget to subscribe to my YouTube channel for more tutorials!