Question

how to creat a drop down list in MS-excel
​

Answer 1

hope it helps

Explanation:

Create a drop-down list

1. Select the cells that you want to contain the lists.
2. Select the cells that you want to contain the lists.On the ribbon, click DATA > Data Validation.
3. Select the cells that you want to contain the lists.On the ribbon, click DATA > Data Validation.In the dialog, set Allow to List.
4. Select the cells that you want to contain the lists.On the ribbon, click DATA > Data Validation.In the dialog, set Allow to List.Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.