excel中如何创建多级菜单实现数据的逐级选择录入（How to create multi-level menu in Excel to realize data step by step selection and input）.docVIP

excel中如何创建多级菜单实现数据的逐级选择录入（How to create multi-level menu in Excel to realize data step by step selection and input） How to create multi-level menu in Excel to realize data step by step selection and input People often engage in work chart may encounter similar problems: in the preparation of EXCEL format, in order to provide convenience to the users of financial statements, compilers often need to use the helper data validity as part of a cell in a table can make drop-down selection menu. In this way, the table user can easily select the options in the drop-down menu to complete the data input. Moreover, the advantage of this is that the optional range of data is set to avoid the input of nonstandard data. A few days ago, a MM colleague asking me a question: how to choose the multi-level menu in EXCEL production, so that each sub menu options and a menu of options, in completely subordinate relationship, but does not appear in other unrelated items. And because of the large number of menu options at the table in the MM table, she encountered a bottleneck when the input character exceeded the upper limit when using the data validation settings drop-down menu. At first glance, the problem seems tricky, primarily how the affiliation between the father and son menu is established. In other words, how to let son find Daddy?. However, after careful consideration, I quickly found a breakthrough and successfully completed this seemingly intractable problem. Next, we illustrate with an example. The MM problem can be equated with the following example: the company developed a domestic market with production and sales of frozen dumplings, there are four different areas, different regions have established their respective marketing agency, marketing agencies of different sales with different characteristics of the product (as shown in Figure 1). Figure 1 The first step is to first solve too many menu items, and use the data validity to set the drop-down menu when the input char