![how to make a drop down list in excel for numbers how to make a drop down list in excel for numbers](https://www.masterdataanalysis.com/wp-content/uploads/2015/07/Create-Dropdown-in-Excel3-1280x720.png)
Now, we need to create a second list to display the Tours.
![how to make a drop down list in excel for numbers how to make a drop down list in excel for numbers](https://images.techhive.com/images/article/2016/05/06-the-now-function-provides-todays-date-100660298-orig.png)
A drop-down list will now appear in the Country field.From the Data Tools group, click Data Validation.Let’s now set up the first drop-down list using Data Validation. Repeat steps 1 to 5 for 'Bali', 'India', 'Thailand', and 'Australia'.NOTE: The selection you make here determines the name of the named range. From the Defined Names group, click Create from Selection.To make this easier, I am going to create a named range for ‘ Countries’, ‘ Bali’, ‘ India’, ‘ Thailand’, and ‘ Australia’. I am aiming to create a drop-down list in cell B14 that lists the countries and a drop-down list in cell B15 that lists the tours available in whichever country has been selected in cell B14. In this example, I am going to use the INDIRECT function to create two dynamic data validation drop-down lists.
![how to make a drop down list in excel for numbers how to make a drop down list in excel for numbers](https://cdn.mos.cms.futurecdn.net/2DsqBbzis9psee4CTmv6nK.jpg)
There are many ways to create dependent drop-down lists so let us look at a couple of them.Įxample 1: Creating a Dependent Drop-down List
#How to make a drop down list in excel for numbers update
If I were to select ‘Sales’, the list of team members would update to show the team members in that particular team. However, what if you want to have multiple dependent drop-down lists? In the example below, the ‘ Team Member’ drop-down list is dependent on the selection made in the ‘Department’ drop-down list. In the above example, I have created a single data validation drop-down list to make it simple for anyone to select an app and input it into the cell. Data Validation drop-down lists are a powerful Excel feature. Creating a list of items for the user to select from is not only an efficient way to input data into a cell but also ensures that the data going into the cell is the same every time, helping to keep the spreadsheet error-free and consistent.