Excel: define drop down list for a cell

When defining a drop down list for a cell in Excel Data Validation, the valid values have to be on the same worksheet. A work around to this is to define the values as a named list first (I.E. name "Departments"), then reference the list name in Data Validation ( "=Departments"). Details here.