Drop down lists can greatly facilitate data entry. Here’s a look at how to use Microsoft Excel’s data validation feature to create handy lists within your worksheets.
In web forms, surveys, and polls, it can be very useful to limit the choices for a selection with a simple drop down list. This is also possible in a Microsoft Excel spreadsheet, but the process isn’t very well known or very intuitive.
In Access, you can limit user entries by forcing users to choose a value from a list control. Microsoft Office applications use the same functionality in built-in drop down lists.