Using a Drop Down List for Data Validation in Excel
Related Tutorial: Text only version - Creating a Drop Down List in Excel Pt. 2
Creating a drop down list in Excel allows you to enter data into a specific cell of a worksheet from a preset list of entries.
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.
This part of the tutorial covers creating a drop down list on a different worksheet within the same workbook.
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.
Tutorial Topics
