Edit Drop Down List

L

Lynn S

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?
 
M

MartinW

Hi Lynn,

Highlight your input cell goto Data>Validation 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
 
Top