Saturday, November 23

Tag: dropdown list in excel

Mar32023 by excelhelp13No Comments
Create Dynamic Dropdown list with Indirect formula

Create Dynamic Dropdown list with Indirect formula

Data, tips & Tricks
A Dynamic dropdown list or dependent dropdown list is very useful while working in Excel. Which makes our work easier and time get saved. Here we have an example of how to create a dynamic dropdown list or dependent dropdown. Example- We have names of some states and their cities. While working in Excel, you should create a dropdown list so that you do not have to type the name of the state or it's city repeatedly. If we select the state name in dropdown the list of cities of that state will appear automatically. We have the following data. In which dropdown list is to be created in column F3 to G6. Steps- To create a dropdown list of state names Select  F3 to F6   In the Data tab, Click on Data Validation. In the dialog box that opens, select “L...
Read More
Jun162022 by excelhelp13No Comments
Create drop down List in Excel.

Create drop down List in Excel.

Data, tips & Tricks
STEPS : Prepare the list for drop-down in Excel sheet.Select the cell or range where you want to create a drop-down.Go to View tab.Click on Data Validation.In the Data Validation dialogue box, . Choose “List” from Allow drop-down.Type or Select the range of source data in source box.Click OK Note- you can create a drop-down in same sheet or in other sheet and can pass the referecne according to the requirement. See the Result in Below Image. Remove/Delete Drop-Down in excel. Select Cell or Range, who has drop-down that you want to Delete.Go to view tab.Click on Data Validation.In the Data Validation dialogue box, Click on Clear All.Click OK. See the Result in Image below.
Read More