edit drop down list

[dyouden]

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?

 

[Gary''s Student]

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.

 

[Risky Dave]

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

 

[dayanara tater]

Hi,

I also had this issue. Now I see the source but do not understand what it means. The source is
=$I$5:$I$15

Please help.
Thank you!

 

[CellShocked]

That is telling you that the column of data you selected to be the drop
down list is located at cell position I5 and from there down to cell
position I15, explicitly so.

 

[veronica wcvx]

Thank goodness for users willing to share. This hint worked and saved me unforeseen hours of look up and deciphering cryptic manuals. Thanks again.