Then, customize the list using the data validation options.

How to create drop down list in excel different sheet. This places the cells in a group so that you can name the group. Select the cells that you want to contain the lists. On the ribbon, click the data tab, and click data validation.

Web select and copy the source list range in the source workbook. Web list the items for the dependent list, and then select the cells. With the cells selected, go up to the.

To remove an item, press delete. In the source box, enter the formula that indirectly refers to table1's column named items. Or select a range of cells on the sheet containing the.

Web in the allow box, select list. In the dialog, set allow to. Simply click the arrow and select an option.

Web to add an item, go to the end of the list and type the new item. In the data validation dialog. On the insert tab, in the tables group, click.

You can add or delete items from your drop. 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.