A common use of data validation is to create a drop-down list. Use it to restrict the type of data that users enter into an Excel cell.

Drop-down lists in an Excel sheet 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.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.

References Microsoft Office Excel: Apply Data Validation to Cells Tech Republic: How to Add a Drop-Down List to an Excel Cell Microsoft Office Excel: Insert or Delete a Drop-Down List ...