In the dialog, set allow to list.

How to create hidden drop down list in excel. Select data validation to open the data validation dialog box. Then, customize the list using the data validation options. Web select a cell in which you want the dropdown to appear (d3 in our case).

You can add or delete items from your drop. On the data tab, in the data tools group, click data validation. Web list the items for the dependent list, and then select the cells.

Select one or more cells where you want the picklist to appear. With the cells selected, go up to the. In the data validation dialog.

And unhide them if you need to make changes. Web on the ribbon, click data > data validation. Web to prevent people from selecting names twice, use this data validation trick, to hide the used items in an excel drop down list.create one formula in a works.

Web @sebastianszyroki if you want to show/hide columns based on selection of option from choice column, you can use conditional formulas in sharepoint. This places the cells in a group so that you can name the group.