How to use Data Validation (Drop Down Lists) (Excel 2007 & Excel 2010)
Creating a drop down list in Excel can help to keep data entry to a specific number of choices. This feature is called Data Validation, and can be used for many different things.