This problem requires two actions, one is to define the name, and the other is to validate the data: Step 1: Make a column full of provinces and give it a name. The name manager will use it. ? Define the name as "province", for example, this province includes Anhui Province, Jiangsu Province, etc.; there are many more names, which are for the cities under each province, for example, there are three cities under Anhui Province: Hefei, Huangshan, and Lu'an. You name these three cities "Anhui Province", and you also need to name other provinces one by one; Step 2: In the column where you need to select a province, such as column A, use data validity, select list, and finally Enter =province below; then in the column of city selection, assuming it is column B, use data validity, select list, enter =indirect($a1) at the bottom, and then drag both columns down. Copy the formula. After completing these two steps, you are good to go and you can achieve the effect you want. I didn’t copy and paste, I just typed it by hand. I’ve thought about doing this before, and after researching and testing it many times, I finally succeeded, so I’m here to share it with you.