How to Create a Drop Down List in Microsoft Excel?

Paul Bryant20 Jan, 2022Business

In a new worksheet, type the entries you want to appear in your drop-down list. Select the cell in the worksheet where you want the drop-down list Select the cells that you want to contain the lists. On the ribbon, click DATA > Data Validation. In the dialog, set Allow to List. Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.