Excel Pick From Drop Down List

Choose list option is allow and select the cells for main category names which in this case is at b2 and c2 cell month and weekdays as we can see a drop down list is created which asks the user to choose from the given option.

Excel pick from drop down list. To achieve this right click on the sheet tab of sheet2 and click on hide. Creating the drop down list in excel. After you create your drop down list make sure it works the way you want.

In the data validation dialogue box within the settings tab select list as validation criteria. Select the cell or range of cells where you want the drop down list to appear c2 in this example. Create a drop down list.

If you dont want users to access the items on sheet2 you can hide sheet2. On the second sheet type the items you want to appear in the drop down list. If the list of entries for your drop down list is on another worksheet and you want to prevent users from seeing it or making changes consider hiding and protecting that worksheet.

Now select the cell under subcategory and just write the formula in data validation and click ok. To create a drop down list in excel execute the following steps.