Library Workshops

Excel Intermediate - Learning Objective #2:

Create and insert drop-down lists:

Skills and concepts covered:

• Define Name
• Data Validation

Activities:

• From the data worksheet, highlight departments → select from Formulas tab DEFINE NAME → new name and enter name as “Department” (also you can just name the list in the name box).
• On the ClientDept worksheet insert the list by highlighting cells B12-B15 → select DATA VALIDATION from the Data tab → in settings tab select allow list, and enter source =Department, select in-cell dropdown and ignore blanks should be checked off