Important: The heading of each sub-category must be exactly the same as the name in the main category. It is absolutely critical that the data table is set up correctly: The main category (the countries in this example) should be in one column, and the sub-categories (the cities) in the other columns, with the countries repeated as headings. It’s easy, and it only takes five minutes! Step 1: Enter the data In this post I will show a very easy way to make a drop-down list in Excel that changes depending on what you have chosen in another cell.
In a previous post we learned how to make an Excel drop-down menu in 3 minutes.
