1
To begin, open your workbook in Excel.
2
Click on the cell that contains the drop down menu you want to update.
3
Click "Data" from the top menu ribbon.\
Then click "Data Validation" to open a pop up window.
4
Make changes to your drop down menu in the "Source" text field under Settings.
Click "OK" to exit the pop up window.
5
You can now click on your cell and select the down arrow at the bottom right corner to see your updated drop down menu.
