Drop – Down List
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.