How to Add a Drop-Down List in Microsoft Excel?

Paul Bryant27 Jan, 2022Business

If You want to add a Drop down list in Microsoft Excel here are some steps: 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.