In this lessons you can learn how in easy way create a drop-down list in Excel.
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:
Drop-down list that you create will look like this:
As you can see we have a choice among all brands of cars from the table. How to do it?
Start from the table. First, select all brands of cars.
Invent a name for this data. Let it be 'Cars'. Enter the name to the name field and confirm with Enter button.
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.
A dialog box appears. Select 'List' and type the name of our range of cells after the = sign that is in us =Cars
Drop-down list is ready.
Further reading: Multiple Linked Drop-Down List Data Validation Combining Data from Multiple Sheets into one file