Using a Drop Down List for Data Validation in Excel
Related Tutorial: Text only version - Creating a Drop Down List in Excel Pt. 2
The benefits for using a drop down list include:
- making data entry easier
- preventing data entry errors
- restricting the number of locations for entering data
Excel Drop Down List Step by Step Tutorial
Part 1 of this tutorial covers the steps to creating a drop down list with data on the same sheet as the drop down list.
Part 3 of this tutorial covers the steps to creating a drop down list with data in a different workbook from the drop down list.
To use data located on a different worksheet you must create a named range for that data.
Following the steps in the tutorial topics below walks you through creating, using, and changing the drop down list seen in the image above.