In the source box, enter the formula that indirectly refers to table1's column named.

How to create a drop down list in excel that changes other cells. Web enter =age in the “source” box (if you named your cell range something else, replace “age” with that name). Web requested' to '2. It might say a1 or a4.

In the dialog, set allow to list. This will create the drop down 1. On the insert tab, in the tables group, click table.

Web select one or more cells for your dropdown (d3:d7 in our case). Secondly, i want the color (in other drop down list) in column k change the status to green (finished) and in column n to change to yellow. You can place these items in an existing worksheet, or a new.

Select the entire data set (a1:b6 in this example). This means that the user can select the. On the ribbon, click the data tab, and click data validation.

Select the name box above column a and below the excel menu. If you select the list, excel. Web if you want to apply the changes to all the cells containing this particular dropdown, select the apply these changes to all other cells with the same settings option.

On the second sheet, select a list item. Click “ok” and your list will. The “ignore blank” check box is checked by default.