Edit Drop Down List
 

I have created a drop down list in Excel 2003 Ver 11.5.
Now I want to edit, or add to the list. HOwever I get a error message that
states the user has restricted values that can be entered into this cell.
I have gone to Data - Validation, and tried to see my list there, or add to
the list there but that does not work for some reason either.
Where am I going to in editing my drop down list?

Edit Drop Down List
 

Hi Lynn,

Highlight your input cell goto DataValidation and change the source
reference.
i.e. if your source range is $J$7:$J$10 changing it to $J$7:$J$12
will allow you to add two new values in J11 and J12.

HTH
Martin