How to Create a Drop Down List in Excel | Scribe

    How to Create a Drop Down List in Excel

    • |
    • 8 steps |
    • 53 seconds
      1
      To begin, open your workbook in Excel.
      2
      Select the cell where you would like to add a drop down menu.
      3
      Click "Data" from the top menu ribbon.
      4
      Click "Data Validation." Depending on the size of your open window, it may only appear as the icon. You can either look for the icon with green checkmark and red circle, or make your window larger to see the words "Data Validation."
      5
      A pop up window will appear. In Settings, under Validation Criteria, click "Any value."\ Select "List" from the drop down menu.
      A pop up window will appear. In Settings, under Validation Criteria, click "Any value."\ Select "List" from the drop down menu.
      6
      Click in the text field under "Source" and type in the list of drop down menu items you want. Use commas to separate each item.\ Then click "OK" to close the pop up window.
      Click in the text field under "Source" and type in the list of drop down menu items you want. Use commas to separate each item.\ Then click "OK" to close the pop up window.
      7
      To quickly apply the drop down list to the cells below, click on the square at the bottom right of the cell and drag it down as far as you'd like.
      To quickly apply the drop down list to the cells below, click on the square at the bottom right of the cell and drag it down as far as you'd like.
      8
      You can now click in a cell, use the arrow to the right to access the drop down menu, and then make a selection from your new menu!
      You can now click in a cell, use the arrow to the right to access the drop down menu, and then make a selection from your new menu!