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.). 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |