![]() ![]() There are city lists in the workbook, and each list is named to match its country name. This is created by using the INDIRECT function in the data validation settings for column B: If you select USA as the country, cities from the USA appear in the Column B drop down. Select Countries and Citiesįor example, in the worksheet shown below, there’s a drop down to select a country in column A. ![]() We’ll take a quick look at how a basic dependent drop down works, then add flexibility by changing the data validation formula. You’ll see different drop down lists in the same cell! With a bit of Excel magic, you can create dependent drop down lists, so the selection in one drop down controls what appears in the next drop down. You can use data validation to create drop down lists in Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |