Create a Drop Down List

You can use Data Validation to create a Drop Down List that looks up the values in a table. This Timesheet will lookup a list of clients in a Table. The clients will be names of cities in this example.

 

There are 3 steps to creating a Drop Down List

1. Create the reference table

2. Name the reference table

3. Use the Named Range in the Validation Settings.

 

1. Try This: Create the Reference Table

Go to a blank spreadsheet. Enter the following:

In Cell A1 type: Ann Arbor

In Cell A2 type: Chicago

In Cell A3 type: Detroit

In Cell A4 type: Flint

In Cell A5 type: Brighton

In Cell A6 type: Boston

In Cell A7 type: Houston

In Cell A8 type: Denver

 

2. Try This, Too: Name the Reference Table

Select A1:A8.

Name the Range: Clients.

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.5. Apply named ranges in formulas

Formulas ->Defined Names-> Define Name