You can add a drop-down list in various cells of an Excel worksheet. A drop down list gives you flexibility to choose one value from the list and you actually need not type the items if it is a fixed set.
Adding list is very easy. Just follow these steps:
1. Write down all the items in a column and select the range.
2. Go to Formulas > Name manager and add a name. (let's say "abc")
3. Select the cell where you want to create the list.
4. Go to Data > Data Validation.
5. Select Type as List and it's range as " =abc "
6. You will see the items in the form of a drop-down list.
Watch this video tutorial to see the complete process.
xTremeExcel
Website : http://www.extremeExcelSolutions.weebly.com
Youtube : https://www.youtube.com/user/xtremeExcel