First of all, let's talk about the effect we want to achieve, that is, after we select the 1 level menu, the content corresponding to the 1 level menu will appear in the secondary menu. When we select an item in the secondary menu, the tertiary menu will produce the content corresponding to the secondary menu, and so on. Let's talk about the principle of realizing this function, which is to set names for the contents of different columns, and this name happens to be an option in the menu at the next higher level. In this case, the function in data validity actually reads the content in the area corresponding to the reference noun, which also reads the menu content of our next level.

2

Next, let's prepare the data. According to the principle described in the first step, I color-coded the column names so that everyone can understand them.

three

From 1 level to level 3, the high-level item is the column name of the next level, which is the format of our data source. If a netizen asks, is it ok not to add these column names? The answer is: yes, if you don't add the column name, you need to know the content of the next level corresponding to each column, plus it is just for the convenience of viewing.

four

Then there is the difference between Office2003 and versions above 2003. To make names, we need to make them one by one in 2003. For example, after 20 13 can be selected, the system will create it by itself according to the selected area. However, it is also beneficial to create them one by one, that is, we won't have some values appearing twice. Next, we will create them one by one. First, we will create Baidu's secondary content. Select the data area.

five

Click Ctrl+F3, or choose Insert-Name-Definition from the menu bar.

six

It should be noted that the system will default the contents of the first cell in the selected range to the name of the current workbook, and we need to change it to the next higher-level name. Here, its upper level is "Baidu".

Click Add and the name of the workbook will be added. The same is true of the rest.

After all the additions are completed, we have finished naming the required data area.

Next, we prepare the table, and we need to relate the data in the table at multiple levels to achieve the desired effect.

We select the institution name, and then select data validity in the menu bar.

Select "Sequence" as the validity condition, and directly select the content item under the organization name as the source.

After confirmation, we will find that there will be content items under the name of the organization. Of course, many people may already know this step, so I won't explain it much.

Next, we associate the secondary content, and also select Data-Validity in the menu bar and Sequence as the validity condition, but we need to use INDIRECT (target cell) in the source, and then click OK.

In this way, we will find that the association of the secondary menu already exists, and there will be no duplicate menu items of 1 level.

Next, we associate a level 3 menu, which is consistent with a level 2 menu. In the source, we need to use INDIRECT($F 14).

In this way, our three-level menus will be related, including four levels, five levels or even more, which can be realized in this way.