When you enter data in Execl, you often need to use the two-level drop-down menu. Maybe some friends don't know how to do the drop-down menu. If you don't know, you are welcome to study together. The following is the tutorial of making two-level drop-down menus in excel2003 that I brought. I hope it will inspire you after reading it!

Excel2003 two-level drop-down menu making tutorial;

Make a secondary menu step 1: set the data source area. Just put the name and model of the mobile phone into the following format for later use and store it anywhere.

Making a second-level menu Step 2: Define names in batches. After selecting the cell phone name and model area, open the window for specifying the name (in excel2003, insert menu-name-specify, 07 and 10 formula tab-defined name group-created according to the selected content), and select? First line? Check box. As shown in the figure below.

Making a second-level menu Step 3: Set data validity. Select the model column to open the data validity window (see yesterday's tutorial for the opening method), and enter = indirect (D5) in the source.

Step 4: Make the secondary menu: After completing the following settings, the secondary linkage menu is set.