How to Create a Drop - Down List in Excel

In this lessons you can learn how in easy way create a drop-down list in Excel.

What is a drop-down list?

What exactly is a drop-down list? It allows you to more easily enter the cell, pre-selected words or numbers. Drop-down list is also useful if you want to impose certain content entering the cell. Sometimes you want all the cells in the column were content YES or NO.

You will create a drop-down list, where you will be able to choose the brand of the car. Here is the table prepared for car brands:

Excel drop down list table

Drop-down list that you create will look like this:

Excel drop down list

As you can see we have a choice among all brands of cars from the table. How to do it?

How to create a drop-down list?

Start from the table. First, select all brands of cars.

Excel drop down list check data list

Invent a name for this data. Let it be 'Cars'. Enter the name to the name field and confirm with Enter button.

Excel drop down list name box

Now select the cell (or cells), which has a drop-down list to appear. We go then to the data tab on the ribbon and press the button Excel Data Validation.

Excel drop down list ribbon data validation button

A dialog box appears. Select 'List' and type the name of our range of cells after the = sign that is in us =Cars

Excel drop down list Data Validation source

Drop-down list is ready.

Further reading: 
Multiple Linked Drop-Down List
Combining Data from Multiple Sheets into one file