![how to make a drop down menu in excel 2016 how to make a drop down menu in excel 2016](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/data-validation-window-in-excel.png)
Go to the Data Tab on the ribbon and from the Data Tools group, choose Data Validation.Under the Settings tab, click Clear All and then OK. Select the cell with the drop down list.
![how to make a drop down menu in excel 2016 how to make a drop down menu in excel 2016](https://www.zerodollartips.com/wp-content/uploads/2018/12/create-drop-down-list-in-excel-300x182.jpg)
To remove a drop down menu Excel lets you do this in two main ways. This item should no longer be in the drop down menu. Right-click the cell and select Delete.ģ. Select the item that you want to be deleted from your drop down menu.Ģ. To do this, go to the original sheet containing the names of the products. You may have a situation where you want to delete a product from the drop down menu.ġ. Now when you return to your sheet with your drop down menu, you should see the list has been updated. Once you have done this you will see the the following.ĥ. Right-click the cell and select Insert.ģ.
![how to make a drop down menu in excel 2016 how to make a drop down menu in excel 2016](https://i.ytimg.com/vi/wCkp-gqN3Q8/maxresdefault.jpg)
You may have a situation where you want to add a product that is not in the original list.ġ. Go to the Data Tab on the ribbon and on the Data Tools group, choose Data Validation and in the Error Alert Tab uncheck the check box that says Show error alert after invalid data is entered. To do this select the cell containing the drop down list. Tip: You can allow the user to enter another item that is not in the list, when necessary.
#How to make a drop down menu in excel 2016 password
![how to make a drop down menu in excel 2016 how to make a drop down menu in excel 2016](https://i.ytimg.com/vi/UwSXwz28vRs/maxresdefault.jpg)