Web to make a picklist from this table, the steps are:

How to create drop down list in excel from table. This places the cells in a group so that you can name the group. In the source box, either update. On the data tab, in the data tools group, click data.

The cleanest way to set something like this up is to create a new tab in excel where you can configure all of your. Start by adding a table containing your dropdown list of items. Web list the items for the dependent list, and then select the cells.

Web select a cell in which you want the dropdown to appear (d3 in our case). On the ribbon, click the data tab, and click data validation. Web the thing with this table is that on the drop down menu i can see the names, but if i choose a name instead of show the name on that cell n2 it shows the.

In the data validation dialog. Web this is the most flexible method for adding list items in a dropdown list. In the dialog, set allow to.

Select the cells that you want to contain the lists. Select one or more cells for your dropdown (d3:d7 in our case). Then, customize the list using the data validation options.

With the cells selected, go up to the. Web @sebastianszyroki if you want to show/hide columns based on selection of option from choice column, you can use conditional formulas in sharepoint. Web with the two named formulas in place, you set up data validation in the usual way ( data tab > data validation ).