I hope these general ideas help you a bit. Hi Don Quixote, I apologize Im not posting code right now, but Im away from a computer. In fact, companies from hospitals and insurance carriers to banks and more use drop-down lists, check boxes, combo lists, and/or radio buttons to minimize typing and user errors. xlsx file Create-a-drop-down-list-containing-only-unique-distinct-valuesv3.xlsx. This is how most wholesale and retail companies handle their product lines. This works very well for ordering and inventory purposes because it divides all the products into manageable categories. This allows you to select a product category from the main menu drop-down list box (such as Beverages), then display all the related products from the submenu (dependent) drop-down list box (such as Apple Juice, Coffee, etc.). Open an Excel workbook click Data tab Go to the Data Validation menu under the Data Tools group Click the adjacent Drop-Down select Data Validation Select.

This is especially useful for fields that require specific information fields that have long or complex data that’s hard to spell or fields where you want to control the responses.Ĭreating dependent drop-down lists (when combined with an INDIRECT function) is another benefit. Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of valid choices that you or others can select for a given field.

Create a drop down list in excel