Create a Drop-down List in Excel

To create a drop-down list in Excel, execute the following steps.
1. On the second sheet, type the items you want to appear in the drop-down list.

We can also hide the list appeared and it's sheet so that users can not see it
2. On the first sheet select cell a1
3. Select the data tools group in data tab and select data validation

4. On the allow list box click list and select range of the cells 5. Click in the source box and select the range from second sheet