May 25, 2013
Use drop-down lists to ensure that the value in a cell matches one of a set of pre-defined values, for example a list of departments. Drop-down lists are part of Excel’s Data Validation feature, a process of applying rules that restrict what users can enter on a...