Web list the items for the dependent list, and then select the cells.

How to create hidden drop down list in excel. You can add or delete items from your drop. Select cell b3 to make it the active cell. Then, customize the list using the data validation options.

Select one or more cells where you want the picklist to appear. Web there are two types of drop down lists available (i am not sure since which version). On the data tab, in the data tools group, click data validation.

Web select a cell in which you want the dropdown to appear (d3 in our case). Activex drop down you can set the column widths, so your hidden column can. With the cells selected, go up to the.

In the data validation dialog. Web on the ribbon, click data > data validation. This places the cells in a group so that you can name the group.

And unhide them if you need to make changes. Web @sebastianszyroki if you want to show/hide columns based on selection of option from choice column, you can use conditional formulas in sharepoint.