1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Data Validation List from another Worksheet

By

1 of 8

Using data from another Worksheet in the Data Validation List
Excel Data Validation List

Excel Data Validation List

© Ted French

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

©2014 About.com. All rights reserved.