How to Create Drop-Down List in Excel

Step 1: Select the Cells

Select the cells in which you want to apply Data Validation.

Step 2: Go to the Data Tab, and click on Data Validation

Step 3: Select Data Validation from drop-down

Three options appear, again click on Data Validation.

Step 4: Select List from the type of data

A pop-up opens. Inside the Allow, select the type of data you want to allow in that Drop Down List. Most frequently, we use List. So, click on List.

Step 5: Select Cells from the worksheet

A Source Option appears. Now there can be two ways to fill the Source Option either write the Text that you want to allow inside that cell or select the cells inside the worksheet whose value you want to allow in your List. After that click Ok.

Step 6: Select Value from the list

Now the List looks like this. You could select any value from that list.

Step 7: This makes our work easier and faster.

How to Create a Dependent Drop Down List in Excel

Dependent Down Lists allow you to validate the data and make the data entry and data filtering very smooth and time-saving. Dependent Down Lists increase the chances of fewer errors in one’s worksheet. The prerequisites for learning Dependent Drop Down List are Create from Selection and Drop Down List.

Sometimes you may want to use more than one drop-down list in Excel, Such that the items available in the second Drop-down list are dependent on the selection made in the first drop-down list. These are called Dependent drop-down lists.