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