Hi, if as i suspect this is a data validation list then you can't.
How to create long drop down list in excel. Select the cell where you want the first (main) drop down list. Start by adding a table containing your dropdown list of items. In the dialog, set allow to list.
You can add or delete items from your drop. Explore training > join microsoft 365 insiders > In the data validation dialog.
Eight is the only setting and to get. Web select a cell in which you want the dropdown to appear (d3 in our case). Web here are the steps to create a dependent / conditional drop down list in excel:
Includes keyboard shortcuts to select items,. Web this is the most flexible method for adding list items in a dropdown list. On the data tab, in the data tools group, click data validation.
With the cells selected, go up to the. Web list the items for the dependent list, and then select the cells. This places the cells in a group so that you can name the group.