top of page

How to add Drop-Down list in Excel

Microsoft Excel is a tool that can be used for various purposes, including data analysis, budgeting, and financial planning. One of the features that make Excel so useful is the ability to create drop-down lists. Drop-down lists are a great way to provide users with a set of predefined options, making it easier to input data accurately and consistently. In this article, we will show you how to add a drop-down list in Microsoft Excel.

Data entry is quick and more accurate when you use a drop-down list to limit the entries people can make in a cell. When someone selects a cell, the drop-down list’s down arrow appears, and they can click it and make a selection.

How to add a Drop-Down List in Excel

Follow the below steps to create a drop-down list in Microsoft Excel:

STEP 1: Suppose I want to create a drop-down list for Apple products. Now, select the cell where you want to create a drop-down list. See the below image:

STEP 2: Now, on the ribbon, go to Data and select Data Validation.

STEP 3: A prompt box will appear. Here, select the "List" from the "Allow".

After that, in the source, enter the names of the product which you want in a drop-down list. Enter the names with commas between them.

For example, for Apple, I have entered "iPhone, Macbook, Ipad".

STEP 4: Click OK.

STEP 5: Click on the cell and select the product from a drop-down list.

How to Delete a Drop-Down List in Excel

To delete a drop-down list, follow the above steps from SETP 1 to STEP 3. When a prompt box will appear, click on "Clear all". Then, click OK.

If you need to remove all Data Validation from a worksheet, including drop-down lists, then you can use the "Go To Special".

STEP 1: Press Ctrl+G => Special.

STEP 2: Data Validation => All or Same, and repeat the steps above.


Drop-down lists are a great way to make data entry easier and more accurate. They can be used for a wide range of applications, from product types to budget categories. With this tutorial, you should be able to create drop-down lists in Excel with ease.


bottom of page