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

6 of 8

Entering the Data Source and Completing the Drop Down List
Excel Data Validation List

Excel Data Validation List

© Ted French

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

©2014 About.com. All rights reserved.