When we use Excel** in our daily office learning, we often use the drop-down menu, a data verification tool, which can provide the data you need to selectIt is also possible to effectively limit the scope of input. If there is a large amount of data that needs to be processed, you can also set up multi-level drop-down menu linkage, that is, the lower-level drop-down menu is automatically displayed according to the higher-level drop-down menu, so as to save our time in finding browsing data. So how do you make this multi-level drop-down menu?Let's take an example to share with you how to make it. Excel Tips
Example: Make a drop-down menu
Methodological steps
1. Open Excel**, create a new data source worksheet, and sort out the data by the level required by the drop-down menu, and set the header of the next level to the content of the next level
Press and hold the Ctrl key, select all the data contents in the data source worksheet, and then click [].Formula] - Create from Selectionin the dialog box that pops upSelect First Row, and then click OK.
3. In the worksheet of the Settings drop-down menu,Select the blank cell below the first-level menu, click[Data] - [Data Validation] - [Data Validation].The Data Validation dialog box is displayed.
Note: In some versions, "data validity" is simply "data validation".
4. In the "Data Validation" dialog box, click [Settings], set the parameters, and then click [OK], so that the first-level drop-down menu is set.
Allow" is set to:Sequence
* "Click on the rear arrow to pick up:."A first-level content cell area in a data source worksheet
5. Continue to the worksheet in the Settings drop-down menuSelect the blank cell below the secondary menu, click[Data] - [Data Validation] - [Data Validation].The Data Validation dialog box is displayed.
6. In the "Data Validation" dialog box, click [Settings], set the parameters, and then click [OK], so that the secondary drop-down menu is set.
Allow" is set to:Sequence
* "Input:=indirect($a2)
Note: [$a2It means that "$a$2" locks the column twice by F4, and $a$2 refers to the first cell in the first-level menu column
7. Set the drop-down menu in the same waySelect the blank cell below the menu, click[Data] - [Data Validation] - [Data Validation].In the pop-up "Data Validation" dialog box, click [Settings], set the parameters, and then click [OK], so that the drop-down menu is set.
Allow" is set to:Sequence
* "Input:=indirect($b2)
Note: [$b 2] means that "$b$2" is to press F4 twice to lock the column, and $b$2 refers to the first cell in the secondary menu column
8. And so on, if you want to make more drop-down menus, repeat steps 5 and 6indirect formulacells in are modified toThe first cell in the previous menu columnCan.