Now whenever you add further rows of data to the Advisory named range, the validation drop down list will keep updating.

Select the name (Advosors) and click on OK.

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. Now go to the cell where you want to create the drop down list and go to Data > Validation > Allow > List and in the source box, tap the F3 key. 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.). If the list is short, you can avoid Step 1. 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. You can add the drop-down list to multiple cells by selecting the appropriate cells or copy/paste the cell with a list. 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.

Add a drop down list in excel