spot_img

Drop – Down List

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:Excel drop down list tableDrop-down list that you create will look like this:Excel drop down listAs 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.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.

Template

You can download the Template here – Download
Further reading: 
Basic concepts 
Getting started with Excel
Cell References
Combining Data from Multiple Sheets into one file
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell

RELATED ARTICLESMORE FROM AUTHOR