Excel Data Validation List from another Worksheet

By Ted French, About.com Guide

Entering the Tutorial Data

The first step to creating a drop down list in Excel is to enter the data.

Note: the tutorial instructions do not include formatting steps for the worksheet.

This will not interfere with completing the tutorial. Your worksheet will look different than the example on page 1, but the drop down list will give you the same results.

Enter the data below into the cells indicated on sheets one and two of an Excel workbook.

Tutorial Steps

1. Enter the following data into the correct cells on Sheet 1 of the worksheet:

            D1 - Cookie Type:     
   

2. Click on the Sheet tab for Sheet 2.
   
   
3. Enter the following data into the correct cells on Sheet 2 of the worksheet:
   
   

            A1 - Gingerbread 
            A2 - Lemon
            A3 - Oatmeal Raisin  
            A4 - Chocolate Chip  
            
   

The drop down list will be added to cell E1 on sheet 1.

Previous

• 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

Next