Skip to Main Content

Library Workshops

Excel Intermediate - Learning Objective #2

Excel Intermediate - Learning Objective #2:

Create and insert drop-down lists:

Skills and concepts covered:

  • Define Name
  • Data Validation


  • 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

Telephone416-864-5059 Email icon           Twitter icon   Health Sciences Library Blog                Health Sciences Library Feedback