This will open the code window for that.

How to add drop down list in excel from another sheet. The names for each group should match the list. Select a cell ( a2 in the worksheet named january, in this example) on which we’ll. If the item you want to delete is somewhere in the middle of your list, right.

On the ribbon, click the data tab, and click data validation. Web at first, we need to create a dropdown list with the sheet names. In the source box, either update.

On the data tab, in the data tools group, click data validation. Back on the first sheet, select the blank cell to the right of the first label. Simply click the arrow and select an option.

Right click on a cell dropdown. In the dialog, set allow to. Click data data validation add rule.

Change to the workbook that is to contain the dropdown and select the new worksheet (list) select. Select the cells that you want to contain the lists. Web to add an item, go to the end of the list and type the new item.

If you don't want users to. Web enter “@.” in the menu, under the components section, click “ dropdowns. at the top, click insert dropdown. To remove an item, press delete.