Comma Training Page 175

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

Create a new, blank sheet. 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.