edit drop down list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dyouden - 22 Feb 2008 13:59 GMT

I have an excel 2003 worksheet that was designed by my predecessor. She used
data validation to create a drop down list with a number of names. However we
need to add a couple of extra names to the list and I can't seem to figure
out how to edit the list. I could just erase the list and create a new one, I
suppose, but I was hoping for an alternate route.
Is there a way to edit this list and add the new names?

Reply to this Message

Gary''s Student - 22 Feb 2008 14:06 GMT

Just click on the cell and:
Data > Validation > Settings
and the source field will tell you where the list is. You can then edit
that list.

Signature

Gary''s Student - gsnu200770

> I have an excel 2003 worksheet that was designed by my predecessor. She used
> data validation to create a drop down list with a number of names. However we
> need to add a couple of extra names to the list and I can't seem to figure
> out how to edit the list. I could just erase the list and create a new one, I
> suppose, but I was hoping for an alternate route.
> Is there a way to edit this list and add the new names?

Reply to this Message

Risky Dave - 22 Feb 2008 14:08 GMT

Hi,

From the menu bar (assuming you are not using Office 2007):

Data>Validation>Settings

The "Allow" box should be set to "List"

The "Source" box will contain one of two things, either the list of valid
values for the drop-down or a reference to the cells elsewhere on the sheet
that contain the valid values. Edit either as appropriate.

Note that if a cell reference is used, the text may have been set to white
and the cells locked to try to hide them from accidential/intentional change.

HTH

Dave

Reply to this Message