Short or Full Excel Drop Down List
You can make data entry easier in Excel, by create a drop down list with data validation. Sometimes those lists are so long, that they become a pain to use. Here’s a technique from AlexJ, that lets users switch between a short or full Excel drop down list of customers.