Excel Data Validation List from another Worksheet

By Ted French, About.com Guide

Entering the Data Source and Completing the Drop Down List

Since the data source for the drop down list is located on a different worksheet, the named range created earlier will be entered in the Source line in the dialog box.

Tutorial Steps

1. Click on the Source line


2. Type " = cookies " (no quotes) in the Source line


3. Click OK to complete the drop down list and close the Data Validation dialog box


4. A small down arrow icon located on the right side of cell E1


5. Clicking on the down arrow should open the drop down list containing the four cookie names entered into cells A1 to A4 on sheet 2


6. Clicking on one of the names should enter that name into cell E1

• Using data from another Worksheet in the Data Validation List
• Entering the Tutorial Data
• Creating a Named Range for the List Data
• Opening the Data Validation Dialog Box
• Using a List for Data Validation
• Entering the Data Source and Completing the Drop Down List
• Editing the List Items
• Options for Protecting the Drop Down List