Simply click the arrow and select an option.

How to add drop down list in excel from another sheet. Web with the cells selected, go up to the name box on the left side of the formula bar and enter a name for the cell group. In the dialog, set allow to. On the ribbon, click the data tab, and click data validation.

Select the cells that you want to contain the lists. Web enter “@.” in the menu, under the components section, click “ dropdowns. at the top, click insert dropdown. Web to add an item, go to the end of the list and type the new item.

Select a cell ( a2 in the worksheet named january, in this example) on which we’ll. On the data tab, in the data tools group, click data validation. If the item you want to delete is somewhere in the middle of your list, right.

Web select and copy the source list range in the source workbook. Back on the first sheet, select the blank cell to the right of the first label. The names for each group should match the list.

Web it’s easy and we’ll show you how. In the source box, either update. Web select a cell in which you want the dropdown to appear (d3 in our case).

Click data data validation add rule. Right click on a cell dropdown. Web at first, we need to create a dropdown list with the sheet names.