Oct 25, 2013
An often-asked question (to me anyway) is “I’m creating a form in Excel. How do I create a drop-down list?” There’s several ways to set up a drop-down list in Excel and this tutorial covers the Data Validation method. Data validation allows you...
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...
