To create these dependent drop-down lists, execute the following steps.
Result: Tip: If you don't want users to access the items on Sheet2, you can hide Sheet2.
As a result, a second drop-down list contains the Pizza items.
You can also type the items directly into the text box, without using Sheet2.Click in the Source box and type indirect(B1).The 'Data Validation' dialog box appears.On the Data tab, in the Data Tools group, click Data Validation.Name, range Address, food, a1:A3, pizza.On the second sheet, create the following named ranges.On the first sheet, select cell.
To achieve this, right click on the sheet tab of Sheet2 and click on Hide.
Here's what we are installer game the sims 3 trying tally erp 9 4.8 crack to achieve: The user selects Pizza from a drop-down list.
Drop-down lists in, excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values.As a result, the second drop-down lists contains the Chinese items.B1:B4, pancakes, c1:C2, chinese, d1:D3.This example describes how to create dependent drop-down lists in, excel.For example, the user selects Chinese from the first drop-down list.On the second sheet, type the items you want to appear in the drop-down list.Next, select cell.Result: Explanation: the, indirect function returns the reference specified by a text string.This gives the exact same result.