Web go to the data tab and click on data validation in the data tools group.

How to create drop down list and filter in excel. Select the cells that you want to contain the lists. Create named ranges for each list: If you don't want users to.

Category = e4:g4, vegetable = f5:f10,. On the ribbon, click the data tab, and click data validation. Web create the lists you need.

Web list the items for the dependent list, and then select the cells. Then, customize the list using the data validation options. With the cells selected, go up to the.

Select a cell in which you want the dropdown to appear (d3 in our case). Web you can download the excel file from the following link and practice along with it. This will open the code window for that.

Web there are three main stages to complete this action. This places the cells in a group so that you can name the group.