How to insert a drop-down list in Microsoft Excel

  1. Open an Excel workbook.
  2. Choose a cell to house your drop-down menu.
  3. Navigate to the Data tab at the top of the screen. It’s nestled between Formulas and Review atop the Ribbon. 
  4. Click the Data Validation button.
  5. Under Settings, find the menu that says Allow, and choose List from the options.
  6. Highlight the cells you want to include in the selection options of your drop-down menu, and click OK. If this doesn’t work for you immediately, click the box marked Source first and then highlight.

How to insert a drop down list in Excel - 45How to insert a drop down list in Excel - 21How to insert a drop down list in Excel - 28How to insert a drop down list in Excel - 16How to insert a drop down list in Excel - 7How to insert a drop down list in Excel - 78