Web list the items for the dependent list, and then select the cells.
How to create drop down list in excel 2007. Edit your cells on sheet1, for example car, year, price. Web select a cell on your spreadsheet and click on the ‚äúdata‚äù tab. In the dialog, set allow to.
This will open the code window for that. With the cells selected, go up to the. Select the data you want to use and type a name for it in the name.
You can add or delete items from your drop. After that, go to sheet2. Add a list of car.
This places the cells in a group so that you can name the group. On the ribbon, click the data tab, and click data validation.