# How to add drop down list in microsoft excel

> To add a drop down list in Microsoft Excel, click the target cell, open Data Validation from the Data tab, choose List under Allow, add the source items or select existing cells containing the list, and click OK to make the drop-down appear in the selected cell.

Canonical: https://livedemo.ai/tutorials/how-to-add-drop-down-list-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2d96d673bd5aa8e5f436/preview?step=1

## Steps

1. Click on the cell where you want the drop-down list.
2. Click on the "Data" tab and select "Data Validation"
3. In the dialog box, under Allow, choose "List."
4. Add Your List Items under source.
5. Select cells in Excel that already contain your list.
6. Once added click on "OK."
7. Your drop-down list will appear in the selected cell.