Create a drop-down list in Excel


Excel 2013

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

  • On the Data tab, click Data Validation.

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

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

  • Click OK.

Excel 2016

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

  • On the Data tab, click Data Validation.

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

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

  • Click OK.

Excel Online

Drop-down lists can't yet be created in Excel Online, the free online version of Excel. However, you can view and interact with a drop-down list in Excel Online, as long as you added the list to your worksheet in the Excel desktop application. Here’s how you can do it if you have the Excel desktop application:

  • In Excel Online, click Open in Excel to open your file in the Excel desktop app.

  • In the desktop app, create the drop-down list.

  • Now, save your workbook.

  • In Excel Online, open the workbook to see and use the drop-down list.

Excel for Mac 2016

You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow, and then clicks an entry in the list. To create the list, use the data validation feature.

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

  • On the Data tab, click Data Validation.
  • Click the Settings tab, then in the Allow pop-up menu, click List.

  • Click in the Source box, then type the text or numbers (separated by commas) you want to appear in the list.

  • To close the dialog box, click OK.