A drop down list can be used to make data entry easier, but it can also be used to limit the data entered into a cell to the items in the drop down list. This method of data validation can prevent data errors from being entered into a database.
Using a Drop Down List for Data Validation in Excel
Excel Drop Down List Tutorials
This step by step tutorial covers creating a drop down list with data located on the same sheet as the drop down list.
Drop Down List Using Data from a Different Worksheet
Excel Drop Down List Tutorials
This is a continuation of the tutorial listed above. This part of the tutorial covers creating a drop down list with data located in a different worksheet from the drop down list.
Drop Down List Using Data from a Different Workbook
Excel Drop Down List Tutorials
Part three of this tutorial covers creating a drop down list using data located in a different workbook (Excel file) from the drop down list.
Creating a Drop Down List in Excel Text-only Tutorial
Excel Drop Down List Tutorials
This is a bare bones version of the drop down list tutorial listed above. It is intended for those familiar with using Excel's Data features.
Creating a Drop Down List with Data on a Different Worksheet Text-only Tutorial
Excel Drop Down List Tutorials
This is a bare bones version on creating a drop down list using data from a different worksheet listed above. It is intended for those familiar with using Excel's Data features.
