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

2 of 8

Entering the Tutorial Data
Excel Data Validation List

Excel Data Validation List

© Ted French

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.

©2014 About.com. All rights reserved.