Use of Indirect Function : Returns the reference specified by a text string. So in B2 Cell now you will see the drop down list for country austrelia or the value which is available in A2 Select Cell B2 -> Click on Date Menu -> Data Validation -> Select Settings -> From Allow Drop-down select value as List -> in Source Text box provide value as “=indirect(A2)” and Click on Ok Button. Step 5) Now Create the Dependent Drop down list. Step 4) Now In Create the First Country drop ListĬlick on Data Menu -> Data Validation -> Select Settings -> From Allow Drop-down select value as List -> in Source Text box provide value as “=country” and Click on Ok Button. Step 3) Create the Named list of Austrelia and Germany as mentioned below. Step 2) Now Create the NamedList for City belong to India as mentioned below. To Create the named list select the values, here Select from cell value from A2 to A4 and then click on the Name Box left of the Formula Bar.Provide name as “Country” and press Enter. Step 1) Create the Country list then select those country and create the named list. In this article will see based on selection of country drop down related city drop down should get populated. Then, select the cell to the right of a dropdown list and go to the Insert tab.To populate the list based on selection,microsoft excel is providing feature of dependent drop down list. To begin, download the drop-down-arrow.png file (right-click on that link and select Save link as). When selecting the dropdown list, the down arrow button for the list displays over the image we inserted. We're going to insert that image in the cell to the right of the dropdown list, so you see a down arrow button even when the dropdown list is not selected. We took a screenshot of the down arrow button on a dropdown list in Excel. We're going to get around this problem by adding a permanent down arrow button to the right of the dropdown lists. The down arrow button on a dropdown list goes away when the cell is not selected. Make the Dropdown List Arrow Always Visible If you would rather not apply different formatting to dropdown lists, the next section shows you another way to make them always visible. Now you can format these cells to differentiate them from other cells, so you know where all the dropdown lists are.
0 kommentar(er)
