![]() The first drop down list has been created.Ħ. In the Data Validation dialog, under the Settings tab, choose List from the Allow section, and type =Country into the Source textbox, Country is the range name you give to the counties in step 1. ![]() Then select a cell you want to create the first drop down list, and click Data > Data Validation > Data Validation. Define scenic cells of each country as named range and name with a country name. ![]() Select the country names, go to the Name box, give a name for the range, press Enter key. ![]() Create a drop down list from another drop down list by using Namesįor example, here are some country names, and every country has its own scenic spots, and now I want to create the first drop down list about country name, and then create the second drop down list about the scenic spots, which means that, I only can choose the scenic from of the second drop down list based on the selected country in first drop down list.ġ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |