Click on the cell that contains the drop down menu you want to update.

Click "Data" from the top menu ribbon.\
Then click "Data Validation" to open a pop up window.

Make changes to your drop down menu in the "Source" text field under Settings.

Click "OK" to exit the pop up window.

Click the Select a range on the sheet text field

You can now click on your cell and select the down arrow at the bottom right corner to see your updated drop down menu.

Click the E7, Contains Data Validation dropdown menu. text entry area

This guide provides step-by-step instructions on how to update a drop down list in Excel. Users can easily modify the options available in their drop down list, making it more relevant and useful for their data entry needs.

Want to make guides like this in seconds? Yes, it's really that fast.