How to Edit an MS Excel Drop Down Menu

1. Launch Excel.
2. Select the cell with a drop down menu in it.
3. Click on the Data tab of the Ribbon Interface, and select Data Validation. A dialog box will appear. In Excel 2003, you get to this dialog box by clicking on the 'Data' menu item at the top of the application window and selecting Validation.
4. Look at the 'Source' field. If it has values separated by commas, the only references this menu uses are those values. Change the value. If it begins with an '=' and refers to a word like this: '=List_Menu1,' it's referring to the named range of List_Menu1 somewhere else in Excel. Write down the name of the named range.
5. Click 'OK' to save your changes. If the drop down menu had nothing but comma separated values, you are done.
6. Click on the drop down menu immediately to the left of the Formula Bar and enter the named range you wrote down before. This will cause Excel to jump to that named range and select it for you.
7. Change the values in that named range to suit your purposes. The menu will now reflect those changed values.