Excel Data Validation List from another Worksheet

By Ted French, About.com Guide

Creating a Named Range for the List Data

A named range allows you to refer to a specific range of cells in an Excel workbook.

Named ranges have many uses in Excel including using them in formulas and when creating charts.

In all cases, a named range is used in place of a range of cell references indicating the location of data in a worksheet.

When used in a drop down list, the named range is used as the source for the list items.

Tutorial Steps:

1. Drag select cells A1 - A4 on Sheet 2.


2. Click on the Name Box located above column A


3. Type "cookies" (no quotes) in the Name Box


4. Press the ENTER key on the keyboard


5. Cells A1 to A4 on sheet 2 now have the range name of "cookies"


6. Save your worksheet

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