Edit Drop Down List

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatted cell column in drop down list 1
Dependent drop down dynamic range formula, off sheet. 7
drop down list 3
Drop Down Lists 2007 10
customize drop-down box 1
Created invoices in Excel - not working in Drive 1
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
How do I create a drop down box within a drop down box? 1

Top