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