How to make two second-level drop-down menus in excel correspond to one first-level menu? For example, the first-level menu includes cities, and the corresponding second-level drop-down menus include
How to make two second-level drop-down menus in excel correspond to one first-level menu? For example, the first-level menu includes cities, and the corresponding second-level drop-down menus include regions and people.
I use excel20 10 to click Data-Data Validity-Settings-Allow to select the sequence in the main tab and enter the text you want to display in the source code. The first-level menu and the second-level menu are separated by English commas. English must be punctuated, but Chinese cannot be used.