Oct 26, 2013
In addition to using Data validation, there’s a couple of other ways to create a drop down list in Excel. Both involve using the Developer tab. By default the Developer tab is not displayed. To display it: Click the Office Button (big round button at the top...
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...
