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?

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.
--
Gary''s Student - gsnu200770


"dyouden" wrote:

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

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
"dyouden" wrote:

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

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!

> On Friday, February 22, 2008 8:59 AM dyoude wrote:

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


>> On Friday, February 22, 2008 9:06 AM GarysStuden wrote:

>> 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.
>> --
>> Gary''s Student - gsnu200770
>>
>>
>> "dyouden" wrote:


>>> On Friday, February 22, 2008 9:08 AM RiskyDav wrote:

>>> 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
>>> "dyouden" wrote:


>>>> On Tuesday, June 30, 2009 4:45 PM Abhi wrote:

>>>> You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.


>>>>> On Wednesday, August 04, 2010 8:50 AM kunal jaiswal wrote:

>>>>> hi dude ,
>>>>>
>>>>> thanks i got ,,,,


>>>>> Submitted via EggHeadCafe
>>>>> Microsoft SQL Server DBA For Beginners
>>>>> http://www.eggheadcafe.com/training-...erver-DBA.aspx

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.

On Sun, 19 Dec 2010 02:23:24 GMT, dayanara tater <(E-Mail Removed)>
wrote:

>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!
>