In the data validation dialog.
How to add drop down list on excel cell. Select cell b3 to make it the active cell. Change to the workbook that is to contain the dropdown and select the new worksheet (list) select the. In the resulting dialog, make sure the my table has headers option is selected, and click ok.
Web select the cell (s) that are to contain the list. Web select and copy the source list range in the source workbook. Web simply click any cell in the list and press ctrl + t.
To remove an item, press delete. On the ribbon, click the data tab > data validation. Then, the data validation dialogue box will appear.
Web then, go to the data tab and click “data validation” in the data tools section of the ribbon. If the item you want to delete is somewhere in the middle of your list, right. Select data validation to open the data validation dialog box.
On the second sheet, create the following named ranges. You can add or delete items from your drop. Select the data tools group from the data tab.
On the ribbon, click the data tab, and click data validation. Select the cells that you want to contain the lists. In the dialog, set allow to.